Data from another worksheet

[ragshyd]

Hi,

I have some data in worksheet2, which will be updated frequently. I want to get the field values in the column B automatically in to the next week sheet under column A.

Can some one help me with a Macro for this?

Regards,
Raghu

 

[Smitty]

You'll need to post some more details. Ideally, post a shot of what you have now and the results you want.

 

[ragshyd]

Hi Smitty,

Thanks for the swift response and sorry for not providing all the details

Here is what I need.

I have worksheet 1, which will be updated with some user details. The usernames are updated in Column B (sometimes I may have only 10, and some times 100 also).

The moment it is updated, I need the data from column B copied into Worksheet 2 in column A. I am okay if it overwrites the data.

Hope this clarifies.

Thanks again!

Regards,
Raghu

 

[Shope]

This should work.
Sub copypaste ()

ActiveWorkbook.Worksheets("First Sheet").Activate

Columns("B:B").Select
Selection.Copy

ActiveWorkbook.Worksheets("SecondSheet").Activate

Columns("A:A").Select
Selection.PasteSpecial Paste:=xlPasteValues

End Sub

 

[ragshyd]

Hi,

I am getting error 400 with a red cross

Regards,
Raghu