The way this is normally done is to add a Control Button to the worksheet
that will do the insert operation. The control button will run a macro that
will insert and add the New ID Number.

"JStange" wrote:

I have a project plan that I'm storing in Excel. There are IDs assigned to
tasks that are alphabetical and numerical. For example:

A-1, A-2, A-3...

When a new row is insterted, is there a way to automatically generate the
next ID for the new task?

Thanks for any help that can be provided!