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
From United Arab Emirates, Dubai
Acknowledge(0)
Amend(0)
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
From United Arab Emirates, Dubai
Acknowledge(0)Amend(0)
Dear Ms. Huda,
Since you specifically sought help from GUYS, I wish to look into your requirement. Kindly submit your EXCEL SHEETS for reference, which are missing. Please also mark a copy to my email id. If I can't do it, I will get it done by my colleague.
EFFECTIVE COMMUNICATION - WRITTEN
---------------------------------------
1) Whenever you wish to post your query, kindly support it with relevant documents/information, if applicable, for REFERENCE. This will help us provide relevant information, if available.
2) Please use bullets or point-wise narration for better understanding instead of submitting information in a paragraph.
Looking forward to hearing from you at the earliest.
With profound regards,
From India, Chennai
Acknowledge(0)Amend(0)
294Since you specifically sought help from GUYS, I wish to look into your requirement. Kindly submit your EXCEL SHEETS for reference, which are missing. Please also mark a copy to my email id. If I can't do it, I will get it done by my colleague.
EFFECTIVE COMMUNICATION - WRITTEN
---------------------------------------
1) Whenever you wish to post your query, kindly support it with relevant documents/information, if applicable, for REFERENCE. This will help us provide relevant information, if available.
2) Please use bullets or point-wise narration for better understanding instead of submitting information in a paragraph.
Looking forward to hearing from you at the earliest.
With profound regards,
From India, Chennai
Acknowledge(0)Amend(0)Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
MAIL MERGE AND LABELING.docx
Attendence sheet with excel formatting..... xls
Advanced Excel 2003.pdf