Reputation
Top tag
Next privilege 50 Rep.
Comment everywhere
Badges
1 1 4
Impact
~11k people reached

Mar
19
awarded  Famous Question
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