Hi All,
I have a workbook, with many sheets and many many tables.
Because I have to insert formulas into the top rows of the tables, absolute and relative referencing goes out the door.
So I have ended up programing hundreds of cells via VBA to look something like this.
With some great help from Ali, I have now also introduced PQ into refreshing dependent tables. However, the refreshing has to happen very frequently. Which all leads to the system ssssslllllloooooooooooowwwwwwing down.Please Login or Register to view this content.
Any ideas on how to program better, or just be able to speed this up would be most appreciated. Or do I just have to bide my time and wait for the circular curser to stop spinning ?
Thanks for your help in advance.
Bookmarks