Can I write a macro that will export one row of data (A2:X2) to a table in
Access automatically? If so, can I do that with multiple spreadsheets of the
same ilk going to the same table in Access? I have the summary page in Excel
laid out in a database type of style for ease in conversion to Access.
I originally tried using "Paste Link" from the summary page of the
estimating spreadsheet we use to a master summary page of all jobs and then
linking that page to Access. This is a little flimsy and unreliable with
non-computer friendly people using it. I need something idiot proof that
will work on its own.
I would appreciate any help you could give me, Excel Gods.