Hi helpers,
I have a workbook with 50 +- worksheets. Each worksheet has a similar format.. 24 Rows X approx 20 columns. I'm trying to copy each worksheet into a single worksheet vertically...is this possible with a macro. I have found some macros but I've spent a day working on this from other macros but can't get them to work....Also if possible each time the original worksheets (50) are updated, ( the data in the cells change but not the size of the worksheet) the single worksheet's data would also change... this second bit is not vital as I can just rerun the original macro but it would be nice to have the links.
thansk for your help in advance,
Mark
Bookmarks