Copying formatting

[srizki]

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.

 

[erik.van.geit]

Hi,

this is not "formatting" to my sense but layout of your data
can you provide an example of what you get and what you expect as a result, so basically a table BEFORE + AFTER
post only relevant information

you can use colo's HTMLmaker (see bottom page) or Table-It (see my signature)

kind regards,
Erik

 

[srizki]

Original

EDIT: Removed HTML - Smitty

 

[erik.van.geit]

ORIGINAL ...


and the expected result is ??

 

[srizki]

this is what I want, (I think I used big file, it did not paste both at the same time, Sorry).
I removed the html

 

[srizki]

EDIT: Removed HTML - Smitty

 

[srizki]

You are right Eric, it is layout, not formatting, I am having difficulty putting in html correctly, every time it says the file is too big, and it pastes a part of if, but as you got it correct, I need to change lay out my way, each month without repeating the same thing again and again, cut and pasted rows ans subtotal them, I can do sub-total later but the main thing is lay out.
thanks

 

[plettieri]

Hi:

Having one post with the same questiuon should be sufficient....see my posts.

plettieri

 

[erik.van.geit]

I do not understand what you want (I copied your tables to Excel and can not see what you want to do since the result you posted is only 2 rows of titles + 4 rows of data ) there is no logic for me

+ the layout is ugly due to the "large tables":
click EDIT and clear the posts with large tables, else the entire webpage will stay unreadable (at least it is for me)

the small tables can stay, (but I do not understand)
so try again to be clear

EDIT: didn't see this message

I am having difficulty putting in html correctly

if you use Table-It I can paste the tables at once instead of needing work 5 minutes extra to clean up the mess

 

[erik.van.geit]

Hi:

Having one post with the same questiuon should be sufficient....see my posts.

plettieri

do you mean this is a duplicate ?
can you provide the link ?
please report so the moderators can decide

best regards,
Erik