View Single Post
Old 11-24-2021, 02:14 PM
XDAnalyst XDAnalyst is offline Windows 10 Office 2019
Join Date: Nov 2021
Posts: 1
XDAnalyst is on a distinguished road
Exclamation Excel: Merging specific worksheets from different workbooks into a master file

Hi all,

I'm just starting with VBA, so I would like some help with this task at hand.

I have four Excel files named "C Tier 4", "L Tier 4", "S Tier 4", and "O Tier 4". Within each of these workbooks, there's a tab called "Data" containing information that I need to combine and extract to a master file (another file). Unfortunately, one of the columns in "O Tier 4" is incorrectly placed, so I need to make sure the workbook columns match the name of the master file columns. Also, since I already have the headers on the master file, I would have to combine the data starting on cell A4.

How would I go about creating a button with VBA code to allow me to do that?

Thanks in advance,

Reply With Quote