| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get an exact copy from a lookup reference.(Font style) | Excel Discussion (Misc queries) | |||
| Copy & Paste Forumla - but reference cell is changing | Excel Discussion (Misc queries) | |||
| Copy exact value from one cell to new formula in another cell | Excel Discussion (Misc queries) | |||
| A cell reference in a formula changing | Excel Worksheet Functions | |||
| HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE | Excel Discussion (Misc queries) | |||
Hybrid Mode
