can you cause a worksheet to number rows when data is input ?

  • Thread starter Thread starter meg
  • Start date Start date
M

meg

We are creating a form for vendors to fill that would contain many rows of data. Most likely they will be
copying and pasting their data into it or dumping it from a database somehow into the form, i'm not really
sure, but I would like each row to get numbered as data is entered. They could enter 1 row or 10,000 rows (it
is unknown).

Is there an easy way to do this?
 
You could use a formula in (say) column A.

In A2:
=if(counta(b2:iv2)=0,"",a1+1)

This will extend your print range. I'd apply Data|Filter|autofilter to show
only those nonblank cells (in column A).

Print, then Data|filter|showall
 
Back
Top