No Tags Found!

Mak.Huda
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
skhadir
288

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
sujai.k
1

Dear Mak, here you may use mail merge option. Type the letter head in word and clik on mail merge and pull the data from excel sheet. Try youverself you will learn it very easily.
From Oman, Muscat
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.