Using Control Buttons to consolidate Number of Tabs

[paul29berks]

I wondered if someone could advise me.

I am looking at a report containing approx 25 seperate tabs. Each worksheet within each tab is in the same format only difference being the data I am inputting.

Is there a way of consolidating all 25 tabs into 1 and using a control button manouvre between data?

Hope that makes sense.

Thanks

 

[yankee428]

Paul,

Depending on the version of Excel you are running, have you checked out the Data|Consolidate feature? Might be a time saver.

 

[yankee428]

There is also a great example on http://msdn.microsoft.com/library/default.asp

goto Office Solutions|MS Office XP|Excel2002|Book Excerpt|Excel2002 VBA Programmer's Ref|Chapter 5
read the CurrentRegion Property section.