**Urgent ** Macro to combine multiple Excel sheets where only one sheet has headers

Shakil1

Hi Alteryx Community,

I’m working with an Excel file that contains multiple sheets:

• One sheet (e.g., "Full Data") contains column headers and full data.

• The other sheets (e.g., "DataOnly1", "DataOnly2", etc.) contain only data without headers.

Each sheet has the same structure (same number and order of columns), but only one sheet provides the correct column names.

I would like to create a macro in Alteryx that:

1. Takes sheet names dynamically as input (e.g., from a list).

2. Reads each sheet, whether it has headers or not.

3. Applies the headers from the “Full Data” sheet to the data-only sheets.

4. Combines all sheets into one unified dataset.

Once the macro is built, I plan to use it inside my main workflow and connect it to the Directory Tool to loop through multiple Excel files and process all their sheets accordingly.

Sample data sets are below.   Thanks!

Person Number First Name Last Name Department

1001	John	Doe	HR
1002	Alice	Smith	Finance

1003	Bob	Jones	IT
1004	Sara	Khan	Admin

1005	Eva	Wilson	Sales
1006	Tom	Hall	HR

caltang

Just to help you out.

@Shakil1 - what @apathetichell wrote is the way to do it. But as a beginner, I understand you may not follow it well enough, so I made a different version to achieve what you want. 

Though some caveats - I am assuming your data structure is the same as you described, so I am simplifying a lot more.

If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

For Shakil1.yxzp