Copy Column Numbers only , keep formatting.

[Alcotraz]

Hi Guys,

I am been working on the project for quite some time now, and it just doesnt seem to do what I want.

I need to copy only numbers from Column G Sheet 6 to Column I in Sheet 4 in the same location, so if it finds a number in Sheet6!G11, it needs to be copied to Sheet4!I11 , and I would also like to keep destination format.

Column G has empty cells and texts, but I need to copy only numbers, if it finds text in Sheet6 is it possible to skip it and leave what it is in Sheet4 ?

Many thanks for any ideas.

Aiva

[stnkynts]

Please Login or Register  to view this content.

[Alcotraz]

Thank you for your code, but it still copies text and formats,

So for example in sheet 6 I have.
A- -B
1 TEXT1
2 100%
3 100%
4 TEXT1

and in SHeet 4

A--B
1 TEXT2
2
3
4TEXT2



So I the result would be

A--B
1 TEXT2
2 100%
3 100%
4TEXT2

and it would keep Sheet4 destination

Many thanks,

Aiva

[stnkynts]

Woops, I read your post wrong. I thought you wanted to maintain the source format. Sorry about that. Try this:

Please Login or Register  to view this content.

[Alcotraz]

Thank you it works perfectly,

Really appreciated

[Alcotraz]

If you could also please let me know how do I change to one sheet .

I would also like to copy the same principle from sheet6 column G to Column I .

Many thanks,

Aiva

[stnkynts]

The sheets are set as variables (e.g. ws4 and ws6). If you want to copy and paste into a single worksheet only you simply code for that sheet in the destination range.

For example this line sets the values in Sheet4 (ws4) to be equal to the values in Sheet6 (ws6).

Please Login or Register  to view this content.

If you want it all on sheet6 you would change ws4 to ws6