copy data from one sheet to another

[hh2020]

Hi,

I was able to copy the data from one sheet to another sheet in the same workbook. However, the destination sheet is not refreshed. For example
copy data from sheet1 to sheet2
Yesterday, I have 100 rows on sheet1, run the macro, I have 100 rows on sheet2 also.
Today, I only have 20 rows on sheet 1, when I run the macro, it still shows 100 rows on sheet2 instead of 20 rows.
Please tell me what should I do to refresh the destination every time the source is refreshed?
Thannks

Please Login or Register  to view this content.

[excel_newbie86]

@hh2020 you try

Please Login or Register  to view this content.

YOu can change sheetname for you suit

[hh2020]

Thank you for your prompt respond. How do I only copy the specify columns such as A, F, M and N to the destination sheet?

[vcoolio]

Hello HH2020,

See if the following option works for you:-

Please Login or Register  to view this content.

I've attached a mock-up workbook with the code implemented for you to play with. Click on the "RUN" button to see how the code works.

I hope that this helps.

Cheerio,
vcoolio.

[hh2020]

Thank you,

Is this the complete code?, because I got an error. I can't download your file due to security from the company. Can you please copy the past the complete code so i can try it?

Please Login or Register  to view this content.

[vcoolio]

Yes. Of course it's the complete code. What makes you think it's not?

What error are you receiving?

Read the gold banner at the top of this page which describes how to upload a sample of your workbook. We'll need to see it/test with it in order to be able to help you.

Cheerio,
vcoolio.