Hello. This might be a tough one. I have sets of sheets in my workbook. The format is AB January, BA January, AB February, BA February, etc. I would like to create a summary sheet for each pair. I would like to use the consolidate feature and copy columns A/B into the summary files, using the left column as the key. Spreadsheet attached. Thanks!!
Is the format/layout always the same, for each sheet?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yes, teh values will always be in column B and the reference will be in A. The names will always be BA/AB and full name of month. It gets a little more complicated than that in that there are years after months, so BA January(1), BA January (2) etc. but I'm sure I can figure that piece out. Thanks!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks