View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sm sm is offline
external usenet poster
 
Posts: 13
Default 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