Auto Generate Number for New Task

[BrianH]

Hi,

I need a macro that will generate the next sequential number when I enter a new row/task.

Next sequential number should be 1 number after the total of tasks already in the workbook on different worksheets.

So doesn't matter which worksheet I put the new row/task, it will generate the next number in Column A on the same worksheet.

Any help or input is appreciated.

Thank you

Brian

[davegugg]

How do we know what the total of tasks already in the workbook on different worksheets is?
Do you use an existing macro to enter a new row/task?

[BrianH]

Only macro I have put in is to move a task to another sheet once the "status" column is changed to Completed.

I was thinking that the macro i'm asking about can count how many total tasks there are currently and generate the next number when a new row is entered.
Or look for the highest number there is and generate the next number automactically when i put in a new row in any sheet.

Btw, that number is specific to that task. So any number generated will be in Column A of the same worksheet.

[BrianH]

sorry, if this is confusing.
not sure how else i can put it.
I can attach a sample if it helps.

[JBeaucaire]

Here's a non-macro method.

1) Choose an empty cell and enter a formula that does a 3D lookup across all sheets to find the current highest number...and add 1 to it.

=MAX(First:Last!$A:$A)+1

2) Name that cell NextNumber

3) Create a Data Validation Drop Down list in the column on all sheets where the Task # is being inserted using List: =NextNumber

Now each time you click on the drop down in any sheet it will display a single number to choose from...the next task number.

Check out this sample sheet...try using any empty cell in column A on any sheet.

[BrianH]

This could work.

Thank you very much.