Niranjanrajrishi
Member
Hello,
Can you help me to find a code to consolidate every 3rd worksheets of multiple workbooks? The workbooks can go up to 20 and option to select the workbook at code running would be a nice option. I searched in the net and got some coding but it does not help me to consider 3rd worksheet (name not identical but place is same). At consolidation, the header data should consider only from the 1st sheet (it is same for all worksheets).
Can you help me to find a code to consolidate every 3rd worksheets of multiple workbooks? The workbooks can go up to 20 and option to select the workbook at code running would be a nice option. I searched in the net and got some coding but it does not help me to consider 3rd worksheet (name not identical but place is same). At consolidation, the header data should consider only from the 1st sheet (it is same for all worksheets).