i have a macro that takes info from an estimating sheet and populates another sheet called master. everything does work ok with the routine but it takes 2-3 seconds to run per fixture on each sheet (i have any where from 1 estimating sheet to 130 sheets) and if i have a full complement of estimating sheets then the routine takes 260-390 seconds, which doesnt seem like a lot but when im demo'ing the software to my supervisor, then 4-6 minutes is a long time. so i have been toying around with the idea of creating an array of the items listed on each sheet (there can be 180 items per each estimating sheet).
so the first question is, is creating an array going to save me time on each sheet? if not, then there is no need to redo the routine, i will use it as is.
so the second question is, if i can use an array to get my data copied to the master sheet, what would that routine look like? not asking for you to do any work yet, just wanting to know how the format of the routine would be.
thanks for everyone's help so far, you guys are the bomb!
Bookmarks