Hi everybody,

If anybody can help me on this...

I am doing a follow up expenses with differentes categories.
On each category I have a macro to add a line everytime I have a new expense.
The file is presented like this:
ColumnB: row 26 for example: Title: "Category 1: Getting help for excel"
and then under all the expenses with 1 macro to add a line when necesary.
on this column on each line I have left =B$26, then folowing =B$27....to be able to count all expenses under the same value on the right category.

My goal: I would also like to use Autofilter to analize some category of expenses. So in this example choosing all expense linked with title"Category 1: getting Help for excel".
My Probleme: If I choose this category I have only main title and not all expenses lines as in column B it is equal to main title line but not appear in text.
My first try: I have first add in my macro to do in a way that in column B these =$B26...appear in text so it works but then...if I decide to change main title expenses lines do not change.

My question: would there be a way through the macro to add expense line and that in Column B cells appear in text but that it is still equal to =B$26... for example and change when title change...
or other solution...

Soorry for being long and thanks for any help on this,

Mika