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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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.
    69,990 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!
    69,990 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following