copy an exact formula without changing cell reference

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?
 

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

Similar Threads

Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
External cell reference between two excel worksheets both in One Drive 0
Cumulative formula for word table 0
Excel does not accept text format! 0
Copy addition formula of non-consecutive horizontal cells 2
Copy entire row from another sheet onto first sheet if a unique text matches 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
VBA Coding Help for Beginner 0

Top