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...
PhilHSEP I'd strongly suggest you use ms-access instead, but if you insist on excel, why not a form? Some info here:
https://trumpexcel.com/data-entry-form/
I appreciate the feedback and am getting the feeling that excel macros would be more difficult than just building a simple access database with one table and one form. Does this sound correct to you ?
I am using a tablet that is running off android system and using google drive so they always want to convert everything to thier software which is different as you probably know. I will need to ensure MS software installed and use other browsers etc.... to make access work right ?
Regards and Much thanks