copy an exact formula without changing cell reference

  • Thread starter Thread starter Vidal
  • Start date Start date
V

Vidal

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?
 
Back
Top