So I have this macro that reads a sheet (named A through FFF), which basically copies each sheet to a "master" page, performs some calculations (like adding items up or deleting rows) and then copies the master to a final sheet (called "big master"). with me so far? when i run the macro on just a few pages (like A-F), the routine works like a champ. but when i run in on my big list (A-FFF), then it fails in certain pages (see list below). I have tried recreating the source pages to no avail. i just cant figure out why its doing what its doing. i have included the workbook and most of the problematic sheets (left A which works perfectly, cant upload all the sheets as it makes the file go above 1Mb). the macro that i run is called "grand finale" which isn't so grand now that its not working as expected. i need someone with a critical eye that can deduce what is wrong with my source pages.
Sheets that dont calc correctly:
Sheets T, W, Y, Z, AA, HH, II, UU, VV, ZZ, DDD, EEE, FFF (left this one off so that i could get file size under 1mb)
Estimate Test upload.xlsm
please rename "estimate test upload" to "estimate test", otherwise the macro will fail. thanks