i had a previous project here for a complaints tracking sheet where if you choose that a complaint is resolved the row is automatically copied to the resolved sheet and if it's still pending it's copied to the pending sheet, it was a basic sheet, this time it's a little more complex, it's not a normal table, it's an application form meaning that multiple rows have to be moved and copied to the resolved and pending sheet.
i want it to do the following:-
1- Move data from application form with a press of a button called Submit (next to it is a reset button that deletes all fields without moving data) and make that press to be conditional , when you choose resolved it moves all data to resolved sheet and when you choose pending it moves the data to pending sheet.
2. i also want the submit button to generate a serial number starting with 1001 (resolved and pending sheet have to be connected, for example if you start with resolved and it's 1001 and the next complaint is pending and you submit it it's number is 1002) (i don't know if this is possible please tell me if i am too ambitious) :poly:
3. in the complaint form sheet i want to lock the all cells and force user to type only in fields.
4. Finally there is a search button on top of the form i want it to be used to seach for complaints, for example if you type 1001 and click search it shows you the row which has this number (use the easiest way possible for you i don't it to be a troublesome feature for you guys, as long as the row is shown in a simple way like a prompt or text based or whatever :cul:)
10% is already paid