Hello,
I have a workbook that contains 200 tabs. Each tab has 4 columns (A:E) w/ same header measures, but each tab has varying numbers of rows. The data for each tab starts in cell A2. I would like to create a macro that will select & copy all the data from cell A2 to the end of the data range (which will change for each tab), and then paste the data underneath the last row in my Master worksheet. I want to make sure no data is overlapping. Please help!
Thanks,
Claire
I have a workbook that contains 200 tabs. Each tab has 4 columns (A:E) w/ same header measures, but each tab has varying numbers of rows. The data for each tab starts in cell A2. I would like to create a macro that will select & copy all the data from cell A2 to the end of the data range (which will change for each tab), and then paste the data underneath the last row in my Master worksheet. I want to make sure no data is overlapping. Please help!
Thanks,
Claire