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...
In general, if you want a button to trigger something, it means that a macro is doing the work.
Do I understand right that the button would cut all the data from one sheet and paste it into a different sheet?
Couldn't you just link the "database" tab to the "entry" tab with formulas?
Do I understand right that the button would cut all the data from one sheet and paste it into a different sheet?
Couldn't you just link the "database" tab to the "entry" tab with formulas?
I am not sure how you mean to do that ? I want to enter information in from a field test then once the simple calculations are done (built in to the cells) I would want them to hit "save" or save and send" so that all the numbers cleared out and we saved to various cells in the next tab. Any help on how best to do that would be greatly appreciated.