Copy the data from Different tabs on to one tab
 

Hi
Is there a shortcut in excel 2003 to copy the data from different tabs and
paste it on to one tab and making it a master data tab?
Is there a way to select all the tabs of the sheet and making it the rage
for a pivot table and then get the master data pivot table that way? Then it
will be easy to get the master data from that pivot table.

Thanks
--
SM

Copy the data from Different tabs on to one tab
 

Hi
No shortcut I'm afraid but Ron de Bruin has written lots of code to do this
type of thing.
Take a look at
http://www.rondebruin.nl/summary.htm

--
Regards
Roger Govier

"SM" wrote in message
...
Hi
Is there a shortcut in excel 2003 to copy the data from different tabs and
paste it on to one tab and making it a master data tab?
Is there a way to select all the tabs of the sheet and making it the rage
for a pivot table and then get the master data pivot table that way? Then
it
will be easy to get the master data from that pivot table.

Thanks
--
SM