VBA Code for Header through cell reference.

Hello all!

Im trying generate a pricelist where i want to have data from a cell (from the first sheet), in the header of the first and second sheet.
(Sheet1 is actually a coversheet to go with the pricelist, i want to be able to see on the pricelist (Sheet2) in the leftheader, who we actually made this pricelist for. (name of customer)

Im using a dropdown to get the customer name, find it in coversheet a2.)

This reference of Coversheet A2 needs to be printed in the headers of these two sheets only.
(In my original file i have several other sheets too, but it unnecessary to have it in there.)


I have seen some videos, but lack skill to adjust the code of those.
The ones ive found do print headers from a cell reference, but "a2" from each sheet, not solely from the first one.
Ive seen the "beforePrint" function, that will do for us.
The beforeSave function is also a good option, i think.

Can you guys and girls help me out a bit?

Thanks a lot in advance!

Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your Coversheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make a selection in A2.

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

The headers will be visible in Page Layout view.

You are very welcome.

If it's a fixed text, place the desired text between the quotation marks to the right of LeftHeader.

Please attach an updated file including the second drop down and explain in detail want you want to do.

Try this macro. You must select a value in A2 first and then select the month in A3.

Please Login or Register  to view this content.

My pleasure.