Target.Row

I need to have my first column to increment by 1 automatically once input is recognized in row 2.

Could someone complete this for me?

Please Login or Register  to view this content.

Right now, I am using locked cells in Row 1 as, I am using two statements the first:

Please Login or Register  to view this content.

As, the first row in the column are "labels" and obviously cannot be used.

Then, I pasted this code down the rest of Row "A" (1) to fill-in the rest of the row as input in row "B" became active

Please Login or Register  to view this content.

How can I translate the above to fit this format?

Please Login or Register  to view this content.

I haven't worked with VBA since 2005 and I am just struggling to remember all of this

Thank you!!

Originally Posted by mikerickson

"A" is a column not a row. What cell holds the formula =IF(B3>1,A2+1,"") ?

Pehaps what you could use is

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This is not working for whatever reason?

Help!!!

Originally Posted by mikerickson

The formula is referencing cells in column B, but the Change event puts the formula in Column B.

You said that you wanted =IF(B2>1,1,"") to be put in a cell, which cell did you want that formula put in?

Please Login or Register  to view this content.

Both are in column A with the second pasted down rows starting at Column A, Row 3.

Please Login or Register  to view this content.

This does nothing than give me an error in Column A

Maybe?

Please Login or Register  to view this content.