Copy data from one sheet to another sheet

[geliedee]

Hi All,

can someone help me on my problem?

I have to transfer all the data from Sheet 1 to Sheet two. I tried recording the macro but its not helpful since i am using a dummy data and i will be using the file for hundreds of customers,.

So from Sheet 1 Column A to D should be copied to Sheet to Column A to D also.
And from Sheet 1 Column F to U should be copied to Sheet to Column F to U also.

No data should be deleted..

Hope someone can help. STUCK WITH THIS FOR DAYS.

[Parth007]

Check this

[geliedee]

Hi Parth007, is there anyway to just declare the range?? So it will just copy those poplutaed data

[Parth007]

Will provide you the code asap

[geliedee]

I mean using your code since i'm asking for help about this

[Parth007]

Please check the below

[geliedee]

Hi gaain, yes thats a good idea. How ever, i found a code can you check how can i edit this? Its copying the entire Sheet 1 including the headers.
what i need is to copy only A5 to U5 and doing down.

[Parth007]

Check this....

[tigeravatar]

Hello geliedee,

This code should work for you:

Please Login or Register  to view this content.

[geliedee]

Hi Tiger! Wow! Superb! Just want to ask how can i add the data in cokumn V to AA from Sheet 1 to column AE to AJ in Sheet 2?
And can you add a msg box if the Sheet 1 is blank then it should says "No data"

[tigeravatar]

Updated code:

Please Login or Register  to view this content.

[geliedee]

Hi @tigeravatar,

Thank you so much...
I have an error in this part of the code:

Please Login or Register  to view this content.

Sorry for asking to much.


Attached is the file

[tigeravatar]

Ah, found the error, change the line you're getting an error on to be this instead:

Please Login or Register  to view this content.