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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete rows takes forever 4
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Re. Conditional formating of adjacent cells but down a column 0
Automatically populating new rows with formuals above 1
Extracting a Part of a Formula as Text 5
Conditional Validation In Excel 1
Naming non-contigent cells with vba 5
Can a formula do this? 1

Back
Top