Batch macro for removing the same number of rows from multiple worksheets

[estherb47]

Hello.

I have an Excel file with 16 different worksheets. Each worksheet has 5 junk rows on top that need to be removed. I want to create a batch macro that reads in the sheets (maybe using the list sheet names option into a Dynamic input tool?), removes the first 5 rows, renames according to the new first row of data, and outputs a combined data set.

Here is a sample file to work with. I'm just not able to crack this one. Thank you so much!

[estherb47 · Accepted solution]

Nothing like playing around a bit to solve your own problem....


I was stuck in Excel mode, rather than Alteryx mode, when thinking of how the file will be read. I needed to skip the first 3 rows, not the first 5, with my sample tool.

[JulieH]

Glad you were able to find a solution  @estherb47! Thanks for sharing it with the community, hopefully it will help others as well!