Hello,
I have an workbook with 44 tabs. Each tab is labeled with a number (1,2,3,4...). I want to be able to loop through each tab, copy the title of the tab and be able to paste the title beside the data in the tab. There are two columns in every tab. I want: Column A to have the title, Column B to have the original data and C to have the original data. How can I loop through this and copy and paste the header/title of the tab beside the already existing data?
I am new to excel so,
Any help is appreciated!
I have an workbook with 44 tabs. Each tab is labeled with a number (1,2,3,4...). I want to be able to loop through each tab, copy the title of the tab and be able to paste the title beside the data in the tab. There are two columns in every tab. I want: Column A to have the title, Column B to have the original data and C to have the original data. How can I loop through this and copy and paste the header/title of the tab beside the already existing data?
I am new to excel so,
Any help is appreciated!