I have a workbook that uses multiple sheets. I am trying to make one sheet that compares the different data.
On the sheet that compares the different data I was wanting to create a macro that once you click a field in the combo box the relative data pops up on the screen. I also want the macro to auto matically line the data up side by dside
I have been successful with this macro (with the help of this forum) to pull data from a single page. However, I need this macro to work for all of the pages in my workbook.
Here is the macro that I used to make the combo box work for pulling data from a single work sheet
And here is the code that didnt work when pulling from multiple sheets.Please Login or Register to view this content.
I am also attaching the document that I am trying to run the macro in.Please Login or Register to view this content.
here is a link to my previous thread about the same issue:
http://www.excelforum.com/excel-prog...o-another.html
Bookmarks