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!