Forum Discussion
Entering set of data in one tab and using button to move data to another tab/cells in same workbook
I would like to use an excel 365 file to work as a very simple database. I have created a simple entry tab which appears like a form. I want the entered and calculated cells from that tab to be moved...
Here is the tab with the entry points and simple calculations to figure out data.
Here is the "receiving" tab that I want to move over to the other tab and each time a test is performed the data will be saved on the next open row whatever that is. So one entered or calculated cell on the entry tab would be moved to a corresponding data entry tab column.
Please upload an Excel Workbook instead of images to work with.
Also, which fields are mandatory and should be filled before user clicks the button to transfer the data to the receiving tab? All of them?
I am looking for direction so I can do this, not for someone to do it for me. If you know where I can find this answer any help is greatly appreciated.
Regards
Phil