Copying a formula to column using a value from a particular cell

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

Guest

I wish to copy a formula to a number of rows in a column using a value from a
particular cell in each formula. What is happening is that when I paste the
copied formula the reference to the cell with the value I wish to use is
moved down with the other cell references.
 
If you use absolute references then it should do what you want. For example

=$A$2*6

will always reference cell A2 no matter where it is copied to.

Mike
 
You must log in or register to reply here.

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

Excel Help to copy information from one row at a time to another sheet 1
Excel VBA 1
Find and replace a value within a formula 2
How do I reference a cell as a row number in a formula? 4
Converting a formula to data 3
Cell Reference & formula 5
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Copy paste data from a column to a row 0

Back
Top