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 |
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 |
All times are GMT +1. The time now is 12:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com