Quote:
Originally Posted by Shari C
It moves down column E as I add transactions. Each page is different also, as some categories have more transactions than others.
|
Hi,
You could perhaps use a VLOOKUP as per the attached example.
You could adapt it to use INDIRECT() to update the formulas automatically rather than doing that manually, but for the small amount of 'categories' you have, the effort of setting it up once will be outweighed by the potential worksheet slowdown you will experience by using a volatile formula such as INDIRECT.
Let me know if you need more help.