VBA - Creating Master List (from different worksheets)

johndoe12123

New Member
Joined
Oct 17, 2018
Messages
1
Hi All,

I'm new the forum and have very limited VBA experience. Would really appreciate ANY help with my issue.

Right now, I have 3 different sheets of data, with different number and order of columns. I need to create 1 master list that combines the data from 3 of these sheets, thought not utilizing all columns across all sheets (i.e. pulling data from 6/10 columns from Sheet 1, 4 Columns of data from Sheet 2, 7 columns of data from sheet 3 etc.).

The column headers on the master list should theoretically be the same as those found on each worksheet.

I've basically created the master list using vlookups, but this was extremely tedious and i'm trying to automate the process in the event of a data update. Would really appreciate any help on this. Thanks!!!!
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
10,799
Office Version
  1. 2013
  2. 2010
Platform
  1. Windows
We would need a little more information. What are the names of the 3 sheets and which columns do you want to copy from each sheet? Do you want to copy based on the columns headers? Where on the Master sheet do you want to paste those columns? Please be more specific in your explanation.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,858
Messages
5,766,796
Members
425,379
Latest member
thedoctor00

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top