Copying a column formula

15 pts.
Tags:
I have created a Change Log. the first worksheet is the log itself. The subsequent worksheets are the individual changes (PCO's). An example of one formula that I am using is as follows: =IF('PCO 1'!M4=0,"",('PCO 1'!K18-TODAY())). Is there any way I can copy this and paste it on several lines. eg, PCO 1, PCO 2, etc.? When I do that, it leaves the PCO # the same and increases the other references, which I want to stay the same but on the next worksheet. In short, I want the worksheet ref to increase with the reference cells remaining the same.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    For the part of the formula that you want to remain the same when copying, use a dollar sign ($) before the column and cell identifiers.  For example, for a reference to the D6 cell, write your formula using $D$6.
    83,285 pointsBadges:
    report
  • indy9091
    Thanks. Is there any way you know of to copy worksheets in a similar manner, i.e., so that the computer knows that when it goes to the next line, it should look in the next worksheet for the reference cell(s)?
    15 pointsBadges:
    report
  • carlosdl
    I don't know of a way to do that.

    Good luck!
    83,285 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: