Help!
Is there any way to reference the value of a cell and place it into the header?
In the image below, there is a value for job number entered into merged cells H2 + I2. I would like this to appear as a red "stamp" on the top of every worksheet header in the workbook; ala old style carbon copy paperwork.
MPI Form screencap.jpg
Thankyou!
If responding, please ignore duplicate post and use this one. Got "server error" when posting, so hit it twice and ended up with 2 posts!
You can copy the contents of the cell and then in Page Layout view, paste into the header. Format as you like.
I haven't found any code to do it...yet.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks