I wrote the following macro, and although it gets the job done, I notice that it runs very slowly. I'm guessing that has something to do with the way I've organized it...perhaps the nesting?
Could someone suggest ways of reorganizing this to make it faster?
For context: I have a large range of data in Columns A through L (data in L, labels in preceding columns), and a list of percentages that accompanies that data. I've placed the percentages off to the side in Columns O and P (O contains labels, P contains the actual percentages), and I need to multiply that range of data by each percentage. To do this, I am copying the original sheet and multiplying it by the percentage. This is repeated multiple times until the complete list of percentages has been completed.
Slow Macro - Example -Revised.xlsx
Bookmarks