I have data in 30+ sheets with different schema. I want to
1. Select specific sheets and import the data in one sheet
2. Skip the first 12 rows in all sheets. The 13th row has the field names
Solved! Go to Solution.
@Swetha_L try batch macro and for your second requirement set the input tool to read file from colum12
@Swetha_L - another route to try for skipping rows in addition to @binuacs suggestion is to add a filter to remove the rows you don't need. For example, if column B is always null from rows 1-12, you can add a filter to remove the null rows and will be left with your column headers in the first row. The benefit of this is if one of the inputs changes and the data starts on row 10 for example, the filter will remove the correct number of rows.
Thank you both!