I have a worksheet that extracts from another. On the sheet I also have
calculations that use this information. The sheet that I extract from has
information added to it which fills in from the top down. However my
calculations that are already there do not move down with the existing data,
rather they then refer to the new data.
I shall try and make this a bit clearer with an example

sheet 2 row 1 columns a to d read from sheet 1
sheet 2 row 1 columns e to g calculated using data in colums a to d

new info put into sheet 1

sheet 2 row 1 columns a to d move to row 2 and new data now in row 1
however the calculation does not drop down a row, but does refer to the
original data, and still sits in row 1. I need it to drop down to row 2
alongside the data.

I realise that I could put the new data at the bottom and replicate the
calculations down, but the data is date related and the most recent needs to
be at the top.

I guess there is a simple solution.

many thanks in anticipation

When you MOVE data (instead of Copy or Cut and Paste), the formulas that
reference that data reflects where the data was moved to.
A couple of options off the top of my head (flat as it is :O)...
- Take a look at the Offset function. That doesn't move when data moves.
- Copy/Paste all the data down one row.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Colin" wrote:

I have a worksheet that extracts from another. On the sheet I also have
calculations that use this information. The sheet that I extract from has
information added to it which fills in from the top down. However my
calculations that are already there do not move down with the existing data,
rather they then refer to the new data.
I shall try and make this a bit clearer with an example

sheet 2 row 1 columns a to d read from sheet 1
sheet 2 row 1 columns e to g calculated using data in colums a to d

new info put into sheet 1

sheet 2 row 1 columns a to d move to row 2 and new data now in row 1
however the calculation does not drop down a row, but does refer to the
original data, and still sits in row 1. I need it to drop down to row 2
alongside the data.

I realise that I could put the new data at the bottom and replicate the
calculations down, but the data is date related and the most recent needs to
be at the top.

I guess there is a simple solution.

many thanks in anticipation