Hi all, I have 2 sheets in a workbook. One is a Covering Letter, and the other is a Quotation. The quotation has lots of options and is very complex. One of the options is Branch (since we have different branch offices), and a drop-down list is available to select the appropriate branch. Each branch has its own letterhead.
What I want Excel to do is when a branch office is selected, the letterhead for the entire workbook should change to that of that branch. I have all the letterheads as images in a separate folder on the desktop. At the moment, the letterhead logo is pasted in the Header section of the workbook. If a particular branch is selected from the drop-down list, can Excel change the letterhead in the Header section to that of the selected branch?
Is it possible, or am I asking for something weird and impossible? Come on, guys, need your help.
Thanks a lot
What I want Excel to do is when a branch office is selected, the letterhead for the entire workbook should change to that of that branch. I have all the letterheads as images in a separate folder on the desktop. At the moment, the letterhead logo is pasted in the Header section of the workbook. If a particular branch is selected from the drop-down list, can Excel change the letterhead in the Header section to that of the selected branch?
Is it possible, or am I asking for something weird and impossible? Come on, guys, need your help.
Thanks a lot