Hi Guys,
I need a macro that will take tab from specific array with tab names say (a1:a10, with names 1 through 10), copies a specific range within each tab (say A1:B3) and paste that range into workbook AAA, tab AB, one after another (so A1:B3 will go to rows 2 and 3 and the range from the next tab will go to rows 5 and 6 and so on - i want a blank row between each tab). Could you please help me with it? What is the best way to achieve it? Any already available macro? Appreciate it!
I need a macro that will take tab from specific array with tab names say (a1:a10, with names 1 through 10), copies a specific range within each tab (say A1:B3) and paste that range into workbook AAA, tab AB, one after another (so A1:B3 will go to rows 2 and 3 and the range from the next tab will go to rows 5 and 6 and so on - i want a blank row between each tab). Could you please help me with it? What is the best way to achieve it? Any already available macro? Appreciate it!
