Microsoft Office

Microsoft Office Questions? Ask a IT Expert for Support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Microsoft Office

EXCEL pulldown List: I need to have a pulldown list for a

Customer Question
EXCEL pulldown List (Bonus $50)...
EXCEL pulldown List (Bonus $50): I need to have a pulldown list for a quote sheet to accomplish the following items listed below. 
1. Pulldown to select from both columns A and B (Product Number and Product Description) on ""Flat Rate Sheet". A single list (only one column). 

2. Sequential Order 

3. Pulldown list will update to included addtional rows as new models are added to flate rate 

4. Autotype function enabled for the pulldown list


I have provided the old quote sheet as an example: Upload via wikisend: ID: 204878 


The New Repair quote excel file has three yellow highlighted cells for additional information. Wikisend ID: 722684


 Thanks, Jeff
Submitted: 6 years ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 8 hours by:
12/4/2011
Microsoft Office Technician: John D, Bachelor's Degree replied 6 years ago
John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9,666
Experience: Bachelor of Science - Engineering Consultant
Verified

Hi Jeff,

 

Which of the two files do you want me to work on and set up the drop down lists in?

 

 

Ask Your Own Microsoft Office Question
Customer reply replied 6 years ago
The file labeled "New Repair Quote rev 1".

The other one is an example of the current one we are using.
Microsoft Office Technician: John D, Bachelor's Degree replied 6 years ago

Jeff if by AutoFill you mean AutoComplete then I am afraid you cannot use that feature in Data Validation drop down lists, at least not if you have more than one row of drop down boxes.

 

As for the rest of the instructions they can be done

 

Let me know

 

 

 

Ask Your Own Microsoft Office Question
Customer reply replied 6 years ago
I'm ok with not having autocomplete.

Microsoft Office Technician: John D, Bachelor's Degree replied 6 years ago
Ok, will try to have it ready this morning
Ask Your Own Microsoft Office Question
Microsoft Office Technician: John D, Bachelor's Degree replied 6 years ago

Ok here is a test file for your review prior to releasing payment

 

http://www.2shared.com/file/wRrhrCke/New_Repair_Quote_rev_1a_TEST.html

 

(make sure to click the blue DOWNLOAD button at the bottom of the download page)

 

The formulas and functions are set up for the first two rows (yellow cells).

 

Let me know if it is ok so I can send you the full file with all the functions

 

 

 

Ask Your Own Microsoft Office Question
Microsoft Office Technician: John D, Bachelor's Degree replied 6 years ago

So how did it go?

 

 

Ask Your Own Microsoft Office Question
Customer reply replied 6 years ago
It needs some additional work.

Issues on the Quote Sheet:
The Product Type should not be a list box. It is dependent on Model Number. (I used "Index, Match function to select the Product Type on the old file).

The Description column should be based on columns I1: N1 of the Flat Rate sheet.

The Model Number pulldown list should be able to allow the individual to select either cells on the Flat Rate sheets in column A and B. (Product Number and Product Description). It also not in sequential order.

Below is how it should work.
Process:
1. On the Quote Sheet I would use the Model Number pulldown list select either cells in the Product Number or Product Description on the "Flat Rate sheet".
2. The Product Type should automatically be filled in (No pulldown). It is dependent on the Product Number and/or Product Description.
3. Using the pulldown for the Description pulldown list. I can select between the following options: Repair, Repair (>10 years), Evaluation, Expedite, Factory Calibration, Z17250 and Upgrade.
4. By selecting one of the cells it will automatically populate the cell for the Ext. Price.

Example 1: On the Quote Sheet.
Using the Model Number pulldown list select "SW5250S-3-0-0". This would automatically populate the Product Type "110 SW".
Using the Description pulldown list select "Repair". This would automatically populate the Ext. Price "$3,260".

Example 2: On the Quote Sheet.
Using the Model Number pulldown list select "CSW5550-208-160" from row 495 from the Flat Rate. This would automatically populate the Product Type "145 CI CSW".
Using the Description pulldown list select "Evaluation". This would automatically populate the Ext. Price "$400".

Look at the second file I had uploaded for an example of how it should work.


Microsoft Office Technician: John D, Bachelor's Degree replied 6 years ago

Wow! I have not yet reviewed all your new comments carefully, but I looking at the initial question requirement and the instructions in the file I think I have met the requirements of both (except for the Autocomplete). For that I expect that you release the full payment so I can proceed with the rest of the work. If you do not agree that'sok I will absorb the time I have spent thus far and we will just end it here

 

Thank you

 

 

John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9,666
Experience: Bachelor of Science - Engineering Consultant
Verified
John D and 87 other Microsoft Office Specialists are ready to help you
Ask your own question now
Customer reply replied 6 years ago
1. Pulldown to select from both columns A and B (Product Number and Product Description) on ""Flat Rate Sheet". A single list (only one column). You failed to provide a single pulldown for both columns A and B.
You provide two pulldowns.

2. Sequential Order. The list is not in sequential order.




Microsoft Office Technician: John D, Bachelor's Degree replied 6 years ago

I have based my work on what "I" was able to understand from your description. It i is your obligation to explain the issues properly so that others can understand it. So that burden really falls on the proponent of the project.

 

If you explain it in more details I will be happy to modify whatever needs to be modified, but only after I make sure I get paid.

 

No need to respond if you do not agree

 

 

Ask Your Own Microsoft Office Question
Microsoft Office Technician: John D, Bachelor's Degree replied 6 years ago

Thanks (but that was not the full payment that was offered, based on which I took the question)

 

In the meantime, let's try to understand the first issue. You said"

"Pull down to select from both columns A and B (Product Number and Product Description) on ""Flat Rate Sheet""

 

How can a single cell have a pull down that can select from BOTH lists. Can you please explain? And which cell would that be?

 

 

 

 

 

Ask Your Own Microsoft Office Question
Ask John D Your Own Question
John D
John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9,666
9,666 Satisfied Customers
Experience: Bachelor of Science - Engineering Consultant

John D is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

701 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

588 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

IT Miro

IT Miro

Computer Scientist

157 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Chris L.

Chris L.

Support Specialist

147 satisfied customers

Certified Expert with over 10 years experience.

< Previous | Next >

Related Microsoft Office Questions
CAN YOU HELP ME RETRIEVE MY PRODUCT CODE I JUST PURCHASE FOR
CAN YOU HELP ME RETRIEVE MY PRODUCT CODE I JUST PURCHASE FOR MY MICROSOFT OFFICE … read more
Moses C
Moses C
Bsc
332 satisfied customers
Is there a way to recover a document accidentally deleted
Is there a way to recover a document accidentally deleted from recycle bin? … read more
Chris L.
Chris L.
Support Specialist
Vocational, Technical or Trade Scho
147 satisfied customers
I installed windows 10 update assistant and now I cannot
I installed windows 10 update assistant and now I cannot open Norton or office programs. click-2-run virtualisation handler keeps popping up. … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,275 satisfied customers
I can not open my skype account. No I did not rearranged my
No I did not rearranged my file folder, Microsoft did automatically … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
My fairly new computer does not recognize me and I don't
My fairly new computer does not recognize me and I don't remember ther password. … read more
Josh
Josh
It Support Specialist
Associate Degree
5,140 satisfied customers
Thanks for your time. I am unable to change the line spacing
Hello ~ thanks for your time. I am unable to change the line spacing to single in my document. I went into paragraph, set single as the default however it reverts back to multiple spaces … read more
RussellA
RussellA
Solutions Architect
Bachelor\u0027s Degree
123 satisfied customers
Every time I see more options. I just wrote a note to the
Every time I see more options. I just wrote a long note to the Lawyer tab. Is there any way you can find question and I send a file and sent a team viewer code and password. I was also requested for K… read more
Kris R
Kris R
IT Manager
Computing
2,629 satisfied customers
I need assistance with a formula. It needs to identify
I need assistance with a formula. It needs to identify unique data points of a column, coupled with other data points from other columns. I have an example I can send. … read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
588 satisfied customers
I did not save a word document and deleted it by mistake.
I did not save a word document and deleted it by mistake … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,275 satisfied customers
I bought a new computer and cannot use Word. It says to
I bought a new computer and cannot use Word. It says to activate account, which I *****@******.***--but I've gone through the steps, and the final message says "no license found." … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I can't access the word documents. A box shows up that says
I can't access the word documents. A box shows up that says that states c:\program files x86\microsoft office cannot be opened. I only have access to emails and internet. … read more
Jason Jones
Jason Jones
AAS Information Technology
6,320 satisfied customers
I was just speaking with a tech support person about my
I was just speaking with a Bell tech support person about my computer data usage, which is mysteriously going over my pre-determined plan for 4 months now. He seems to think that Windows 10 is trying … read more
Chris L.
Chris L.
Support Specialist
Vocational, Technical or Trade Scho
147 satisfied customers
My Word doc has a black dot in the red circle on top LH
My Word doc has a black dot in the red circle on top LH corner. it seems to be locking it so I can not open the doc. Please help. … read more
Isaac Franklin
Isaac Franklin
Associate of Science in Social Sciences
968 satisfied customers
You have assisted me in the past. Do you have any experience
Hello, You have assisted me in the past. Do you have any experience pushing an application install using group policy? I need some assistance.Thank you,Yuri… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
588 satisfied customers
I wish to add a gmail account to my outlook (Office 365) I
I wish to add a gmail account to my outlook (Office 365) … read more
UranIT
UranIT
IT Consultant, Network and System Admin
Associate Degree
567 satisfied customers
Can I open a Mac PowerPoint 2011 from a Mac PowerPoint 2013.
Can I open a Mac PowerPoint 2011 from a Mac PowerPoint 2013 … read more
Jason Jones
Jason Jones
AAS Information Technology
6,320 satisfied customers
I have not been able to get to my documents. What so I need
Hi, I have not been able to get to my documents. What so I need to do to read them? … read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
953 satisfied customers
How to get free download. Free download for Microsoft word.
How to get free download JA: JustAnswer requires a modest payment. You'll see the amount on the next page. It's way less expensive than face-to-face would cost. And you're covered by our 100% satisfac… read more
Bryan
Bryan
IT Consultant
8,751 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x