I have a spreadsheet with several worksheets. On each printed page of each worksheet I would like to have references to some fields that i define somewhere in the document.
More specifically, i would like to have a version number, date of approval, in the headers. And I would like to be able to specify those values in cells in the first worksheet.
I want do do it smarter because it's a chore, and error prone, to update it manually.
I'm trying to create something like the quick parts-functionality found in Word. But I can't figure out how to do it.
I have tried to reference named cells, but since the header and footer-field isn't cells, it doesn't seem possible. I've web searched for "create custom header and footer elements", and similar stuff, but found only references to how the the 'out of the box-elemntes" are used. Also, it seems that there is no Quick Parts concept in excel, as there is in Word (which is quite a shame, cause that stuff truly makes me feel like a superuser..
I haven't looked in to creating a macro that solves my problem since i'm not that much of a super-user, but would be willing to dip my toes in the that pool if that is the way to go.
So, any suggestions?