Forum Discussion
Entering set of data in one tab and using button to move data to another tab/cells in same workbook
To suggest a solution you need to show us the the layout of the entry and another tab and explain where the info entered into the entry tab should go on another tab.
Why not upload a sample file with both the tabs where entry tab is filled with entries and the another tab is mocked up manually to show us how the data is being fetched from the entry tab with the help of simple mapping on another tab?
e.g. if the value from cell A2 on entry tab is going into the cell B2 on another tab, just place the formula =Entry!A2 in the cell B2 on another tab.
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