connecting to rows and cells in another sheet (adding new lines/products)

[Watcher05]

Hi

I have spreadsheet to store tonnes captured over a weighbridge. There are 12 sheets for each of the month. There is also another sheet which is for my boss but uses the same tonnages but this sheet is setup completely different. It captures the tonnages from the monthly cells and reflects it in the bosses spreadsheet.

I have to add new products or delete obsolete products. When i do this it puts the values out of sink as its moved down a couple of lines. I thought excel would adjust accordingly but it hasn't.

Is there a way to keep the cells in sync between the corresponding work sheets?

thanks so much.

Dan

 

[Chrisdontm]

Personally, if I am going to set up a sheet to be able to delete rows, I would use the OFFSET formula to describe each range in the formulas.
( It adjusts with rows being deleted.)

I believe the SUMPRODUCT formula does as well, if that helps any...

It sounds like you mainly need these formulas on your boss' sheet...