How can I copy a column "overtime" d5:d35 from pivot table at the sheet1 to the sheet2.
I would like copy only values.
I know that I can select range d5:d35 copy then
open sheet2 paste special only value but I would like to know how write cod
How can I copy a column "overtime" d5:d35 from pivot table at the sheet1 to the sheet2.
I would like copy only values.
I know that I can select range d5:d35 copy then
open sheet2 paste special only value but I would like to know how write cod
Last edited by barkarlo; 10-25-2008 at 11:13 AM.
Can you highlight the range d5:d35, right click / copy, move to the desired location on the other tab, right click / paste special, then choose 'values'?
I'm using Excecl2007 and that works for me.
Hope that helps!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks