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
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