Automatically Format Copied Cells

[DragonPsych]

Hi! I love this place!

I'm running Excel 2007. I will be copying (or cutting) and pasting a row of cells into another worksheet that has accumulated over time. I'd like the cells I'm copying/cutting to automatically "adopt" the formatting of the cells already present.

Basically, the cells in the original worksheet all center justified etc...and the one's in the running list worksheet (it's a running list of clients) are all left justified. I'd like the copied cells to become left justified once they move into the running list. Unfortunately, some columns are left justified, while others are not (although if it would make it easier, that's something that I can change).

I'm a newbie to Excel, am a quick learner so if you write it out, I'm capable of making modifications to work as necessary.

This is kinda what the data looks like...

COPIED FROM:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Record Number[/TD]
[TD]Client Name[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]30352[/TD]
[TD]TEST[/TD]
[TD]07/22/2014[/TD]
[/TR]
</tbody>[/TABLE]

COPIED TO:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Record Number[/TD]
[TD]Client Name
[/TD]
[TD]Date
[/TD]
[/TR]
[TR]
[TD]5452[/TD]
[TD]TEST1[/TD]
[TD]06/20/2011[/TD]
[/TR]
[TR]
[TD]648[/TD]
[TD]TEST2[/TD]
[TD]07/25/2012[/TD]
[/TR]
[TR]
[TD]79842[/TD]
[TD]TEST3[/TD]
[TD]12/08/2010[/TD]
[/TR]
[TR]
[TD]1231[/TD]
[TD]TEST4[/TD]
[TD]07/22/2014[/TD]
[/TR]
</tbody>[/TABLE]

I hope what I wrote was clear...

 

[raygh]

Hello, while pasting, you can right click and select Paste Special. Under Paste Values, there will be an option to Paste Values. If the destination cells have already been formatted, then the copied cells will automatically match the destination format. Hope this works for you.
Thanks.

 

[DragonPsych]

Hello, while pasting, you can right click and select Paste Special. Under Paste Values, there will be an option to Paste Values. If the destination cells have already been formatted, then the copied cells will automatically match the destination format. Hope this works for you.
Thanks.

Doh....guess I should have thought about that. I can also just use the paintbrush thingy to format the whole row based on what's above it.

I guess I was just wondering if there was a code or something that would say: "When cells are pasted into a location, use the same format as the cells above them"...?