I really hope someone can help! I would like to save input data from 3 worksheets (Input1, Input2, Input3) to a another worksheet named DB in the same workbook. I have attached an example workbook for reference. RDW07.xlsm
I have 3 requests to achieve this:
1. If I copy over a specific Entry's data back to all the Input sheets (this button already works in the DB sheet) by clicking on a entry in the DB and then click the Load Entry Data button, and then make changes to the input data, then when you click the Save to Database button then it must save all data back to the DB sheet but on the same line with the same Entry ID# in the database sheet (DB) according to same Entry ID# in cell "C5" in Input1 sheet. So it is basically you just saving (over-writing) any changes made to that specific entry back to the DB sheet.
2. When you click the "New Entry" button on Input1 sheet, then the code will get the next Entry ID# number in the sequence in column "A" of the DB sheet and place this number in cell "C5" on Input1 sheet, but it must not give a runtime error if there are no entries in the DB (clean DB), it should then begin from scratch with E0001 as the new Entry ID# number in the DB if there is none and put this number in cell "C5" in Input1 sheet.
3. After the new Entry ID# has been created (in point 2 above) in cell "C5" in Input1 sheet, and all other data has been captured in all input sheets (Input1, Input2, Input3), Then I would like to save this new Entry and all it's data captured from these Input sheets by clicking the "Save to Database" button, which will then copy all input data from all the input sheets to the DB sheet to the next row of the table under the last row saved as per the column headings.
Thank you for the help!