Compare Data

[lostinformulas]

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

[Trebor76]

Hi there,

I'd say you'll need some code to do this, which I'll try and write for you if you could just confirm for me - in the Summary tab if you want to see say May data, you want the total of May for the three groups, correct?

Cheers,

Robert

[lostinformulas]

Robert,

Actually I want to copy the data for the month for each group and display it next to each other in order to make comparisons.

Row 3 has item headers
Actual
Target
Tolerane
Variance
Blank Cell

Column B4-B29 has the data description which will line up with the information that is imported from each month.

The three group names are:
Cab
Chassis
Mechatronics


I hope this is enough info.


Thanks
Lostinformulas

[Trebor76]

Hi there,

Clicking the Summarise button on the Summary tab, selecting the month to report on from the user form drop-list and then clicking OK should hopefully be what your after.

Let me know how it goes.

Kind regards,

Robert

[tuph]

Hi there,

Clicking the Summarise button on the Summary tab, selecting the month to report on from the user form drop-list and then clicking OK should hopefully be what your after.

Let me know how it goes.

Kind regards,

Robert

Robert,

I've been following this thread 'coz it's something I can use. Thanks very much for your really helpful workbook!

Cheers,

[lostinformulas]

Robert,

Perfect, thank you so much.



Lostinformulas

PS. Maybe someday I be able to figure things like this out.