Subtotaled information paste

owendodd

Board Regular
Joined
Jan 17, 2005
Messages
205
Hey i would like to know how you can paste subtotaled information! Firstly i have subtotaled a table into group then once this is done i wish to just paste that subtotaled information into another sheet!When i simply paste or go to any of the other options paste special it seems to drag over everything that was unsubtotaled! Any ideas please!
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,118,020
Messages
5,569,678
Members
412,287
Latest member
Ardamit
Top