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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!