Macro to copy data from one worksheet to another after existing data

[mihir008]

Hello!

I am a complete newbie to macros, so would greatly appreciate help with the following task..
I have to copy data from one worksheet (which regenerates data every week) to another worksheet, with the following conditions


1. Source sheet has columns A-W. Target sheet should have this same data from A-W
2. Column X in the target should have today's date (for all values copied - for my pivot table)
3. New data from the next week should be copied below the existing data, with column X accordingly updated.

As I said, I am very new to excel macros and would appreciate any help with the code.

Thanks in advance,

Mihir

 

[John Davis]

Hello!

I am a complete newbie to macros, so would greatly appreciate help with the following task..
I have to copy data from one worksheet (which regenerates data every week) to another worksheet, with the following conditions


1. Source sheet has columns A-W. Target sheet should have this same data from A-W
2. Column X in the target should have today's date (for all values copied - for my pivot table)
3. New data from the next week should be copied below the existing data, with column X accordingly updated.

As I said, I am very new to excel macros and would appreciate any help with the code.

Thanks in advance,

Mihir

Does this help? Test first.

Sub mihir008()
Dim lr As Long
Dim lr2 As Long

lr = Sheets("Source").Cells(Rows.Count, 1).End(xlUp).Row

Sheets("Source").Range("A2:W" & lr).Copy Sheets("Target").Range("A" & Rows.Count).End(xlUp)(2)
Sheets("Target").Range(Range("X2"), Range("X" & Rows.Count)).End(xlUp).Value = Date



End Sub

 

[mihir008]

that does it!

thank you so much

Mihir

 

[John Davis]

that does it!

thank you so much

Mihir

You're very welcome. Thanks for the feedback.

 

[shw_11]

Hello!

I have a similar problem. Using this code as an example does anyone know how to alter it so that the values of a cell, rather than its formula will be copied?

Any help will be much appreciated!

 

[John Davis]

Hello!

I have a similar problem. Using this code as an example does anyone know how to alter it so that the values of a cell, rather than its formula will be copied?

Any help will be much appreciated!

I'm sure someone can help you. You need too provide a sample of your data and what you want to achieve.l