copy data in specific columns to another sheet

[steve400243]

Hello, I'm looking for the best way to copy data from specific columns on the WK13 sheet, this will change weekly, to the DATA Tab. Here is what is needed.

from "WK Tab to Data Tab". Starting on Row 3 on the WK Tab. Please see the attached, and please let me know if I explained this good enough.

Column
D to A
E to B
C to C
G to D
B to E
AB to F
H to I

[spitfireblue]

Am I correct in saying that you will have multiple sheets in your workbook and you want to keep adding to the data tab?
If so, try this:

Please Login or Register  to view this content.

[steve400243]

Hello Spitfireblue, thank you very much, I appreciate this. I wont keep adding to the data tab as the WK tab changes. But this will work for what I needed.