Hello all.
I have a standard database, list of people and order numbers etc. I use data entry forms to add/find entries to the database.
I was wondering if it is possible to have the data entry form on a different sheet? For example, sheet 1 would be the "front screen" with the data form on. All data entered would go into the database on sheet 2, without actually opening that sheet.
I have a macro running at the moment so when I click a button on sheet 1, the form appears, but so does sheet 2. I would love it if I could get it to appear on sheet 1!
Any ideas?
Cheers guys,
Tony
Bookmarks