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?


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question