Hi there,

I want to link a number of cells on one worksheet back to another worksheet within the same workbook. Say everything from Cells A1 to M90.

I find the fastest way to do this link A1 on second worksheet to A1 on first worksheet (by using = and click on worksheet 1 Cell A1).
I then click on cell A1 on worksheet 2, grab small square in bottom right hand side of cell, and drag accross to M1.
While A1 TO M1 is still highlighted, I then grab small square on bottom of cell M1 and drag down to M90.

This makes all cells within this range reference back to worksheet1. In advanced settings I have unchecked for all blank cells to show a zero in woksheet 2.

Therefore I now have what I currently want, although I would like to make all reference absolute??
I tried doing this from the beginning again making A1 absolute at the start, but dragging the cells across and down does not provide the info I am looking for in all cells??

Is there a way for me to do this??

Thanks in advance.