srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,851
- Office Version
- 365
- Platform
- Windows
am trying to copy format from one sheet to another, and this is how it goes,
I receive a worksheet every month from another department, and then I sort that worksheet the way we want by moving rows up or down by cutting and pasting.
Let me give an example, in original sheet I receive asset numbers in column A and they are grouped by the location, I change the group by kind of assets regardless of where it is. There are sub-totals and blank rows after sub-totals.
I do this every month. I am sure there must be a better and faster way to do it, can anyone please help me.
I receive a worksheet every month from another department, and then I sort that worksheet the way we want by moving rows up or down by cutting and pasting.
Let me give an example, in original sheet I receive asset numbers in column A and they are grouped by the location, I change the group by kind of assets regardless of where it is. There are sub-totals and blank rows after sub-totals.
I do this every month. I am sure there must be a better and faster way to do it, can anyone please help me.