copy an exact formula without changing cell reference
 

I have multiple sheets in a workbook. Each sheet is identically setup, I can
get the lookup sheet to point where I want, but I would like to copy the data
from all the sheets to one Master list. I have set up the "list" page how I
want it, and now I would like to just copy the columns and change the lookup
sheet name. How do I copy the formulas to another column without excel
adjusting the cell numbers automatically?

copy an exact formula without changing cell reference
 

Hi Vidal,

Use =Indirect("Sheet1!A1") instead of =Sheet1!A1

--
If this post helps click Yes
---------------
Peggy Shepard


"Vidal" wrote:

I have multiple sheets in a workbook. Each sheet is identically setup, I can
get the lookup sheet to point where I want, but I would like to copy the data
from all the sheets to one Master list. I have set up the "list" page how I
want it, and now I would like to just copy the columns and change the lookup
sheet name. How do I copy the formulas to another column without excel
adjusting the cell numbers automatically?