How to Speed up my macro

[manofcheese]

I am trying to speed up my macro because it ends up taking 15 or 20 seconds. Here is my code and here is my worksheet as well. Inventory Management Speedy.xlsm
I think it could be because of the index functions in the code. I received some help on that part on another thread so I don't know how to change it very well. For some reason my code also triggers another private sub macro on the Print Label's tab when I step through it. Any idea how to stop that from happening?

This code is for the tab "Transaction".

Please Login or Register  to view this content.

[manofcheese]

I played around with it a little and this is my new code. It still isn't as fast as I would like. Any suggestions?

Please Login or Register  to view this content.

[k64]

I have a couple ideas for you. First, loops are slow. If you can avoid a loop, do. Avoiding loops If you can't, take as much out of the loop as possible. There is no reason you need to be declaring variables, changing the calculation settings, etc inside the loop.
Second, writing to cells is slow. You want to write as few times as possible. For some reason, excel can write to 100,000 cells faster than it can write to a single cell 100 times. I'd create an array to store your values in, instead of changing cell values, then paste the whole array down at the end.