I have an issues where I am using the directory to pull all excel sheets in a certain folder and then a macro to pull them into Alteryx. Well every Excel sheet has data on the first row that I do not want. I want the second row to be the column titles (which I know can be done with a Dynamic Rename) but I need to get rid of all the first rows to start. I know I could filter but it is causing these first rows of data to mark them as column titles which I do not want. Each month I am going to add a new Excel sheet and that will add a new column title. Any suggestions for deleting the first row of data on each excel sheet before the macro?
