Insert Row and Fill with Formula of Row Preceding It

Quincy

New Member
Joined
Aug 2, 2007
Messages
1
For a given year ‘y’, I would like to create a function that will create (2007 – y) rows, and fill the cells with the formulas of the rows preceding it (all of which contain relative referencing).

How do I go about this?
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
57,412
Office Version
  1. 365
Platform
  1. Windows
Quincy

Welcome to the MrExcel board!

I suspect that your post has not received a reply up till now because readers are not quite sure what you want. Let's try to clarify a few things:

1. Where will the "given year 'y' " come from? Will it be in a cell? Which cell?

2. " create (2007 - y) rows". Where will these rows be exactly?

3. " the rows preceding it". Which rows are these now? Are they the last rows used in the sheet at the moment? Which columns do they use?

4. Do the "rows preceding it" contain only formulas? Or are there other values as well? If both, which columns contain formulas and which don't?

It would be much easier if you could show us a small sample of your sheet (or one like it). Perhaps you would consider downloading Colo's HTML Maker or Excel jeanie to do so? Here are the links to do that:
Colo’s HTML Maker:
http://www.mrexcel.com/board2/viewtopic.php?t=92622
or Excel jeanie:
http://www.excel-jeanie-html.de/index.php?f=1

Failing that, can you describe much more precisely what your sheet looks like (including row/column/cell references, formulas etc) as well as what you are trying to do.
 

Forum statistics

Threads
1,181,658
Messages
5,931,272
Members
436,786
Latest member
Deniel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top