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)
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)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
MAIL MERGE AND LABELING.docx
Advanced Excel 2003.pdf
Competancy--exc el---mts___smts _289.xls