insert a new row by formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to insert a new row based on the value in a cell of an
existing row?

Thanks in advance for any help.
 
Not with a formula, only with VB code. A cell formula can only change the
value of another cell (or cells). It can be done, but you need to give more
information of what you are trying to achieve,
Regards,
 
I bet Alan meant to say that a formula can only return values to the cell(s)
containing the formula.
 
I did indeed! Sorry,
Alan,
Dave Peterson said:
I bet Alan meant to say that a formula can only return values to the
cell(s)
containing the formula.
Click to expand...
 
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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Help to copy information from one row at a time to another sheet 1
insert blank row and formulas 1
insert muliple rows, every 4th row 7
VBA - retrieve data on last create named range from previous inserted named range 0
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Absoute Cell Ref Changes When Inserting New Row in Referenced Shee 8
Insert Properties 1

Back
Top