Automatically populating new rows with formuals above

  • Thread starter Thread starter usawargamer
  • Start date Start date
U

usawargamer

Is there a way to do the following?

lets say there is a range spanning rows 1,2,3, with 3 columns
A1 = B1 + C1
A2 = B2 + C2
A3 = B3 + C3


Lets say I enter a blank row at 2
A1 = B1 + C1

A3 = B3 + C3
A4 = B4 + C4

Is there a way to automatically fill in the formuals on row 2 so when
I insert a blank row I get this:
A1 = B1 + C1
A2 = B2 + C2 <the newly filled in formula>
A3 = B3 + C3
A4 = B4 + C4



The idea behind this is I'd prefer not to have to prefil lots of cells
with formulas, and instead expand them as needed
 

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

Shift down and then to the right 1
use macro to copy formula with value and not formula without value 3
Reconstructing a table with Arrays 1
Re. Conditional formating of adjacent cells but down a column 0
Macro to concatenate columns 1
Macro that analyses 3 columns and put results in 4th 5
Loop by Group Within Group 6
copy multiple columns 1

Back
Top