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
From United Arab Emirates, Dubai
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
From United Arab Emirates, Dubai
Dear Ms. Huda
Since you had specifically sought help from GUYS, i wish to look into your requirement. Kindly do submit your EXCEL SHEETS for reference, which are missing. Do mark a copy to my email id as well. If i can't do then, i will get it done from my colleague
EFFECTIVE COMMUNICATION - WRITTEN
---------------------------------------
1) Whenever you wish to post your query, kindly do support your query with relevant documents/information, if applicable, for REFERENCE. This will help us to revert with relevant information, if we have only.
2) Kindly do use bullets or point wise narration for better understanding rather submitting information in paragraph.
Looking forward to hear from you at the earliest.
With profound regards
From India, Chennai
Since you had specifically sought help from GUYS, i wish to look into your requirement. Kindly do submit your EXCEL SHEETS for reference, which are missing. Do mark a copy to my email id as well. If i can't do then, i will get it done from my colleague
EFFECTIVE COMMUNICATION - WRITTEN
---------------------------------------
1) Whenever you wish to post your query, kindly do support your query with relevant documents/information, if applicable, for REFERENCE. This will help us to revert with relevant information, if we have only.
2) Kindly do use bullets or point wise narration for better understanding rather submitting information in paragraph.
Looking forward to hear from you at the earliest.
With profound regards
From India, Chennai
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.