agnesz
07-09-2008, 02:23 PM
Here's my problem. I need to enter a sum formula in columns BD & BE in the row which has "Total Excluding New Receipts / Cont % TTL" or "Page Total" in it in column B.
I'm attaching a spreadsheet which hopefully explains this better.
The row in which the two criteria "Total Excluding New Receipts / Cont % TTL" or "Page Total" appear will always vary, which is why I'd like a macro to find it for me and enter the formula in those 2 columns accordingly.
Thanks !!!!!!!!!!!!!:motz2:
I'm attaching a spreadsheet which hopefully explains this better.
The row in which the two criteria "Total Excluding New Receipts / Cont % TTL" or "Page Total" appear will always vary, which is why I'd like a macro to find it for me and enter the formula in those 2 columns accordingly.
Thanks !!!!!!!!!!!!!:motz2: