Excel 2007 Copy Multiple Columns into one

[Closed]
Report
Posts
1
Registration date
Monday October 10, 2011
Status
Member
Last seen
October 10, 2011
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I am trying to create a macro that will automatically copy multiple column lists into a single list. Let me clarify.

Sheet 1 contains three multiple column lists > List 1 is columns G through K, List 2 is columns M through Q and List 3 is columns S through W. Rather than have 3 separate lists, I want a single list, that contains all of these lists. In other words, Columns Y through AC would show Lists 1, 2 and 3. That way, I have one consolidated list (List 4), that encompasses all of these lists into one.

I have 6 worksheets in total, with 3 of the aforementioned lists. And in fact, if I could, I would prefer all 3 lists, from all 6 worksheets, to be combined into one master list.

Can you please assist?

Thank you!

Jon


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you post a sample workbook at some file share site and post back the link to the file back here