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