tonyk1051
04-19-2021, 04:56 PM
Hi,
So every 2 weeks i get 2 workbooks, the first workbook has only one worksheet where i have to reorganzie a few columns of data (lines go up to 20000) the 2nd workbook has 3 worksheets, same headers but all in a different order, i have pull all the data from those 3 worksheets into a new worksheet and do that for several columns. So for example header name "item ID" is present in all 3 worksheets but in workheet one its in column W, worksheet 2 has it in column L, etc. each worksheet has usually about 10000 lines. Is there a setting or macro that can do all this in seconds? I ve attached 2 workbooks so you get what i mean.
So every 2 weeks i get 2 workbooks, the first workbook has only one worksheet where i have to reorganzie a few columns of data (lines go up to 20000) the 2nd workbook has 3 worksheets, same headers but all in a different order, i have pull all the data from those 3 worksheets into a new worksheet and do that for several columns. So for example header name "item ID" is present in all 3 worksheets but in workheet one its in column W, worksheet 2 has it in column L, etc. each worksheet has usually about 10000 lines. Is there a setting or macro that can do all this in seconds? I ve attached 2 workbooks so you get what i mean.