Advance Excel Help - CiteHR
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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

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

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.
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™