Excel: Consolidating Data from multiple tabs to a single tab; then based on variable


Thank you for your time. This is my second post and I've learned so much from reading through all of your other responses. THANK YOU for passing along the knowledge and teaching us in the process Here's my issue: - I have a workbook with 15 sheets. - The data from 9 of those sheets (Sheets 5-13) needs to be consolidated into one. (Sheet 2 "CONSOLIDATION - Team") - The data on those 9 sheets is positioned from A3 to I3 with the number of rows varying by sheet, but month. - All of the data is fielded uniformly from sheet to sheet and would like to keep it that way (so pasting Values only). I'm trying to build a single macro that I can assign to a button on the CONSOLIDATION - Team sheet. With all the searching I done, I would have thought I could find out how to do this one, but they all have variations that I haven't been able to muddle through. ___________________________________ Once I have the CONSOLIDATION - Team sheet, I then need to parse the data a bit further - On another of the 15 sheets (Sheet 1 "CONSOLIDATION - Overview"), I need to pull in specific columns of information from the CONSOLIDATION - Team sheet based on a variable in column C - On rows with column C = "Green", copy data in columns A, F and I and paste onto CONSOLIDATION - Overview starting in F5, then continuing down how ever many rows there is data. - On rows with column C = "Blue", copy data in columns A, F and H and paste onto CONSOLIDATION - Overview starting in J5, then continuing down how ever many rows there is data. Easy right????? Thanks in advance for anyone's help.


This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of March 31, 2015.


For more resources for Microsoft Excel