Hunter Childress
Member
I am trying to speed up the exercise of doing lookups on every column for every tab.
I created an output example tab but essentially I have 3 tabs with the same structure but different column headers starting in column E. Column A-D should stay the same position but I would like to combine all 3 tabs into one tab, but pull the header into a column and to the right of that, the item number under that header.
I am trying to create a easier way to look up the data I need thus pulling it all into one column. If it's on 3 tabs, it's a lot of work.
Can you help? Feel free to reach out with questions.
I created an output example tab but essentially I have 3 tabs with the same structure but different column headers starting in column E. Column A-D should stay the same position but I would like to combine all 3 tabs into one tab, but pull the header into a column and to the right of that, the item number under that header.
I am trying to create a easier way to look up the data I need thus pulling it all into one column. If it's on 3 tabs, it's a lot of work.
Can you help? Feel free to reach out with questions.