I want to have the name of the document in the header, but keep the information on a summary sheet for easy updating. Is it possible to use an Absolute Reference in the header while keeping the information on a summary sheet? Thank you.
Reply from Richard Rost:
I'm sorry, Laurie, but I'm still not following. The reason to use an Absolute Reference is so that copy and paste operations (or AutoFill) don't CHANGE the reference to the cell as you move down a column or across in a row. It wouldn't be necessary to do this in the page header.
As far as putting the "name of the document" in the header, there are element codes for the FilePath, FileName, and SheetName. You can use those or type in your own.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel 2010 Expert 1.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
