Copying Functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
One way is to copy the formula direct from within the formula bar, then paste
direct into the formula bar on the destination sheet.
 

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

How do you copy a formula to other cells without changing the for. 2
locking cells dynamically 1
lookup function? 9
Help with SUMIF & AND function 2
converting COUNTIFS formula from Excel 2007 to 2003 6
Comparing Cells 3
Functions 1
Looooooooooooong links. 3

Back
Top