Hello,
I don't use macros too often, and maybe that isn't the best way to go, but I'm not sure how to do this...
I receive an Excel spreadsheet each month that contains information that I want to import into an Access table. The spreadsheet contains what would be 11 records in the database. The information I want to save into the table is scattered in different cells, rather than being in consecutive cells, although the data is in the same cell each month. What I need to do, for example, is import cell A4 into table MyTable, field StartTime...Cell B7 into MyTable, field EndTime, etc. Then, create the next record, where it would import cell A8 into MyTable, field StartTime...Cell B11 into MyTable, field EndTime, etc.
Can this be done using a macro, or maybe I could stumble my way through VBA with quite a bit of help?