Autonumber in a list

[borglindata]

Hi

Have a pivotlist that changes after how I filter the table.

I have put in my pivot table in B6

In A6 I put in the number 1 A7=2 A8=3 A9=4 and so on this I do manuel.

Is it hard to make a VBA that check if:

B6 is emty or not, if it's not emty the number 1 will come in to cell A6
and do a loop until B is emty then stop fill in numbers.

In the same time if I change the filter so that the list is longer or smaller all the numbers in A will also change

Thanks for all help.

 

[borglindata]

Hi

This worked GREAT Thanks for the big help