I have an Excel workbook that's getting out of hand. I need to take some of the data stored therein and import it into Access, so that I can better manage it. Unfortunately, the data isn't in a nice tabled form, so I can either manually make it so or hopefully use some nifty formulas to get the data in a nice format to import to Access.
In the attached workbook on the "dataimportation" sheet, I have entered some formulas that grab the data I need from the "Region 1" sheet. The only data I need is in the column titled "CO" which is the middle column for each month. In subsequent sheets, I only need the values in the middle column(s), but there may be more than one, with two at the most. I've highlighted the ones I need in the Region 2 sheet. The problem with my formulas is that they are pretty static and won't scale well to other sheets with data in different places. I'm sure there are other problems as well.
Can someone please save me from this mess of data? Are there any other ways to get the data besides formulas? Thanks a million.
excel forum - index.xlsm
Bookmarks