Automatically add a new row

  • Thread starter Thread starter yalex
  • Start date Start date
Y

yalex

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
 
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
 
Back
Top