| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying Functions
I copied a cell from another worksheet A
ex. =Sheet1!B12 The info from Worksheet A apears on Worksheet B, the current sheet I am working on. My problem Is when I copy the information from to cell it changes the info, it reads ex. =Sheet1!C12 How can I keep it from going to C12 and Keep the info from B12, without doing it manually? Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying Functions
One way is to copy the formula direct from within the formula bar, then paste
direct into the formula bar on the destination sheet. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Need HELP" wrote: I copied a cell from another worksheet A ex. =Sheet1!B12 The info from Worksheet A apears on Worksheet B, the current sheet I am working on. My problem Is when I copy the information from to cell it changes the info, it reads ex. =Sheet1!C12 How can I keep it from going to C12 and Keep the info from B12, without doing it manually? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
| Copying Columns of Text - WS Functions do not work correctly | Excel Worksheet Functions | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Copying functions from one cell to other cells | New Users to Excel | |||
| Copying and Filling Cell With Functions | Excel Discussion (Misc queries) | |||
Linear Mode
