Form in Excel

Job ID: 34530720

Budget: €30 – €250 EUR

I'm in need of a form in excel.
If possible this form would need to work in excel online since I want multiple people to be able to work with it simultaneously.

There are several tabs in the file.

Full list is a protected sheet where I will upload new records on a dailly basis. This sheet will at some point be protected with a password so no one can touch the records in that specific sheet.

Reminders
This sheet is collecting information from the result work sheet
Based on the Follow up date that was generated it will collect the ones that have a follow up date that is today or in the past.
therecord should only be copied if and only if this specific record is still present in the Full list. If it's not then it means that the record was treated in a correct way an dit should not be copied anymore.

Work sheet
THis tab contains a couple of functionalities
first you have a load button:
When you push this button it will simply load a record from the full list with the oldest "in time"
Afterwards you should be prompted to push one of the buttons below

No contact: will copy the loaded record into the sheet work result and add the chosen action (no contact) + a timestamp of when the button was pushed(so day of today) + it should also add a fu date that = day of today +1

Accepted DIY: will copy the loaded record into the sheet work result and add the chosen action (no contact) + a timestamp of when the button was pushed(so day of today) + it should also add a fu date that = day of today +10

Intervention: will copy the loaded record into the sheet work result and add the chosen action (no contact) + a timestamp of when the button was pushed(so day of today) + it should also add a fu date that = day of today +1


Closed: will copy the loaded record into the sheet work result and add the chosen action (no contact) + a timestamp of when the button was pushed(so day of today) + it should also add a fu date that = day of today +1


Work reminder
Collection of all records that were treated in work sheet

Result work
This tab contains a couple of functionalities
first you have a load button:
When you push this button it will simply load a record from the full list with the oldest "in time"
Afterwards you should be prompted to push one of the buttons below

Accepted DIY: will copy the loaded record into the sheet work result and add the chosen action (no contact) + a timestamp of when the button was pushed(so day of today) + it should also add a fu date that = day of today +10

Intervention: will copy the loaded record into the sheet work result and add the chosen action (no contact) + a timestamp of when the button was pushed(so day of today) + it should also add a fu date that = day of today +1


Closed: will copy the loaded record into the sheet work result and add the chosen action (no contact) + a timestamp of when the button was pushed(so day of today) + it should also add a fu date that = day of today +1

Result Reminder
Collection of all records that were treated in remnder sheet
Final result
This is the a collection of both result sheets(reult work and result reminder)
If a record is in both sheets then it should ONLY copy the record with the last timestamp.

Comparison data
nothing needs to be done with this

The file is going to b eused to call people in regards of a specific issue.
They will be called twice thus the reason why we have a work sheet and work reminder.
We should only call people twice if the first call did not resolve the issue.
Related categories: PHP Visual Basic Data Processing Data Entry Excel