Hi all,
I have a workbook which is only 2MB in size. However it has 5000 rows of data. Since I added a number of sumproduct formulas to the sheet the processing speed has dropped to unbareable levels when making any changes to the data.
I was wondering if anyone could help convert these formulas into a single code which I can trigger from a button?
The formulas are:
Sheet 1.
Cell AA5 (and copied down to AA5005).
Cell AB5 (and copied down to AB5005)
Cell AC5 (and copied down to AC5005)
Cell AD5 (and copied down to AD5005)
Sheet 2
Cell C5
Cell C8
Cell C14
Cell C17
Cell C27
Cell C28
Cell C29
I know this is a big ask, but am hoping that if 1 formula can be converted into vba then they all can easily enough. Where I am completely stuck is whether it can be done with the two arrays in cells C5 and C14 on sheet 2?
Many Thanks,
James
Bookmarks