18 reputation
14
bio website
location
age 26
visits member for 1 year, 4 months
seen Feb 22 at 16:48

Feb
13
awarded  Notable Question
Oct
27
awarded  Popular Question
Jun
18
awarded  Scholar
Jun
18
awarded  Supporter
Jun
18
accepted Adding foreign keys from existing Access tables to imported Excel sheet
Jun
17
asked Adding foreign keys from existing Access tables to imported Excel sheet
Jan
6
awarded  Student
Jan
6
comment Create a form as a worksheet in Excel that adds records to another worksheet
I don't know VBA, but I'm sure I could figure it out. Before I started scripting, I wanted to make sure there wasn't a more obvious solution. And yes, Access (or really any database) would be better suited to this, but everybody at my work has Excel and if they needed to could continue to manually manipulate a spreadsheet. We're talking a place that is still pretty low tech and lives off the three big Microsoft Office products.
Jan
6
asked Create a form as a worksheet in Excel that adds records to another worksheet