I have a workbook with 4 tabs, one of which I want to pull information from all of the other tabs(Group1, Group2,Group3). We'll call that one the summary tab.
I want to pull a months worth of information from the other tabs to compare the groups.
I want to type the month into A1 and have that months information pulled on the the summary tab.
January = column D-H
February = Column I-M
March = Column N-R
Etc.
the data is in rows 4-29
Any Ideas, or have I confuss everyone.
Thanks
Lostinformulas
Bookmarks