Automatically add a new row
 

I wanted to see if there is a way for me to insert a code in cell A1
that will look at cell B2 on another sheet and if there is data in cell
B2 then it will automatically insert a new row under cell A1 and copy
the formula in cell A1 into A2 and have the process repeated until no
more information is available in column B. Thanks in advance for any
assistance.

-yalex


---
Message posted from http://www.ExcelForum.com/

Automatically add a new row
 

What is the result you are trying to produce? If you want a simple
count of cells with information not including "B1" you can do this:
=COUNTA(Sheet2!B:B) - 1


---
Message posted from http://www.ExcelForum.com/