HI,
I am stuck - I have been trying different things with this. I have a macro that compiles the monthly statements from a folder into one workbook. These statements have similar information but with different headers as they come from different sources (i.e. Purchase Order Number might be PO# or P.O. Num, etc.). I am going to create a list of possible examples for each header. I want to create a macro that goes through each tab finds the header from the list and pastes the information below the header in one tab:
The thing is that not all statements will have all the columns - only the invoice # would be there 100% of the time.
Any ideas/suggestions?
Thank you
I am stuck - I have been trying different things with this. I have a macro that compiles the monthly statements from a folder into one workbook. These statements have similar information but with different headers as they come from different sources (i.e. Purchase Order Number might be PO# or P.O. Num, etc.). I am going to create a list of possible examples for each header. I want to create a macro that goes through each tab finds the header from the list and pastes the information below the header in one tab:
The thing is that not all statements will have all the columns - only the invoice # would be there 100% of the time.
Any ideas/suggestions?
Thank you