MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copying Sub Total Results to another sheet

Posted by Donna Wray on November 09, 2001 10:30 AM

Can anyone help me with copying a multiple sub totaled result to another sheet. When I try to copy the sub totaled list, with a paste special, values only function all the background data comes with it? I am looking to copy only the snapshot result and not the data.
Thank You.

Posted by H on November 09, 2001 10:39 AM

Post formula in the cell & what answer you require

Posted by IML on November 09, 2001 11:33 AM

Highlight your list as you would like to see it copied.
Hit control G, special, visable cells only.
Hit control C to copy and then paste it where want.

good luck