Hi all,

I attempted to post something yesterday, but apparently it didn't make it to the board. Anyway, I have a large workbook set up for manual calculation. The purpose of the workbook is to summarize business scenarios based on 2 input criteria...when the criteria changes, the summaries change. I'm looking for code to assign to a single macro button to perform the following refresh/updates after entering new criteria...

1. Refresh forumulas in a separate worksheet for 6 columns in sorder as they build upon one another (~43K records); forumulas are fairly straightforward, but the refresh moves slowly when I do a replace = with =. The 6 building formulas by column are as follows.
X=IF(V2>=Worksheet!$I$5,"LG","SM")
Y=IF(X2="SM","N/A",IF(1-(Q2/V2)>Worksheet!$I$4,"Y","N"))
Z=IF((VLOOKUP(B2,Worksheet!$C$145:$D$183,2,))="x","N","Y")
AA=SUMPRODUCT(--($Z$2:$Z$43134="Y"),--($C$2:$C$43134=C2))
AB=SUMPRODUCT(--($Z$2:$Z$43134="Y"),--($D$2:$D$43134=D2))
AC=SUMPRODUCT(--($Z$2:$Z$43134="Y"),--($R$2:$R$43134=R2))

2. Refresh very basic pivot tables in 5 other worksheets that pull from the above worksheet that acts as my data file

3. Refresh very basic sum/count formulas that look at named ranges from the refreshed pivot tables in step 2 (they reside in the same worksheet as the pivot tables)

4. Refresh 2 tables in another separate worksheet, that pull from both the pivot tables and sum/count formulas in steps 2 and 3

I've searched all over the web and have found answers to solve parts of my questions, but can't pull it together to get anything to finish the job. Seems to hang up in the worksheet in step one, perhaps due to it's sheer size. I'm very much a novice (or even greener!) when it comes to macros, so please treat me as a 5th grader here with suggestions. The simpler the better!

Regards,
Chris