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