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

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