Pull Multiple Column Data from One Sheet to Another

[Katterman]

Hello Excel Gurus

I've searched many similar threads and sites for help on this but even though some similar questions have been posted and answers given, i can't seem to find a scenario that works best or that my limited VBA experience has been able to adapt. I Have tried the record macro approach as well but since not copying and pasting Column to Column (see below) it fails. I always do my best to research before posting to try and avoid wasting peoples time if the answer is already here.

I have a sheet (CleanIt) that contains cleaned up data (done daily so the "end Rows" would not always be the same) that i want to pull the data from 4 columns and paste into different columns (starting in row 2 to avoid header overwrites) on a different sheet (For this example the sheet is called "Work In Progress" but each day would be a different sheet due to data is gathered Daily and the Last Rows would always be different on a daily basis)



[TABLE="class: grid, width: 900, align: left"]
<tbody>[TR]
[TD]Sheets("CleanIt")[/TD]
[TD][/TD]
[TD]Sheets("Work In Progress") [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]*** This is a Table (Table3) That Ranges J1-> AF5000 ***[/TD]
[/TR]
[TR]
[TD]Column "A" up to Last Row[/TD]
[TD]Copy to[/TD]
[TD]Column "AD" Staring in Row 2 (To Leave headers untouched)[/TD]
[/TR]
[TR]
[TD]Column "B" up to Last Row[/TD]
[TD]Copy to[/TD]
[TD]Column "M" Staring in Row 2 (To Leave headers untouched)[/TD]
[/TR]
[TR]
[TD]Column "C" up to Last Row[/TD]
[TD]Copy to[/TD]
[TD]Column "J" Staring in Row 2 (To Leave headers untouched)[/TD]
[/TR]
[TR]
[TD]Column "D" up to Last Row Value of A, B or C[/TD]
[TD]Copy to[/TD]
[TD]Column "N" Staring in Row 2 (To Leave headers untouched)[/TD]
[/TR]
</tbody>[/TABLE]





** Note, The "Last rows" of Data would all be the same for Columns A, B and C with No Blank Cells but Column D would have some blank cells within the column (and want to be kept) and would "technically" end at the same Last row as the other columns albeit there many not be data in the last row(s) of column (D).

The sheet i have can't be uploaded due to sensitive data but If required, i could build a sample workbook but was hoping the above would be OK. If Not, I understand

Thanks in Advance for any and all replies.
Your teachings are most Valued

Scott

 

[bschwartz]

You're welcome. You may need to repost the question, as people sometimes ignore questions that are being resolved. Just make sure you link them together in your second post and post here with a link to the new post.

 

[Katterman]

Thanks Again Ben

As Suggested, i Posted an new Thread HERE that links back to this one as a reference.

Scott

 

[Katterman]

All Resolved Now.

The Final Thread is HERE.

Thanks Ben (bschwartz) and Norie for all their time and assistance.

Scott