Copy multiple columns with varying number of rows into one column on a new sheet and loop

[cammyjane10]

I have columns A-K with a header in row 1. I need to move all the data in rows 2-? (varies) for each column into column A of a different sheet. And if possible, loop twice more for data in columns M-X and data in columns Z-AK. These two would populate columns B and C of the second sheet.

I've got a script that works great except it copies ALL the columns into column A
Can anyone use it as a jump-off point? I'd settle for one script that just copies A-K. I can always run two more modules for the other two data sets.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[cammyjane10]

Works but seems to be pulling data from the sheet that the sheet we're copying is referencing....does that make sense? Needs to pull data/values from my Filter sheet and only copy the cells that have values >0 and skip blanks like the first script I posted.

[JOHN H. DAVIS]

Can you post an attachment with some sample data. Sorry for the late reply been a bit busy.