How JustAnswer Works:

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

Ask Richard Your Own Question

Richard
Richard, Computer Support Specialist
Category: Computer
Satisfied Customers: 35380
Experience:  Over 15 years of consulting to the IT industry
32989067
Type Your Computer Question Here...
Richard is online now

Can you help me with a question about excel

Resolved Question:

Can you help me with a question about excel
Submitted: 2 years ago.
Category: Computer
Expert:  Richard replied 2 years ago.
Thank you for your question, my name is ***** ***** I look forward to assisting you.
Please note, click on Reply to Expert to reply to me, a rating is only needed when we are finished.
Can you tell me please the question you have and I can help you?
thank you
Customer: replied 2 years ago.

I am trying to create an invoicing system in excel. I have a spread sheet with a list off inventory in one column and the selling price in a column next to it. I want to create a dropdown box on my invoice to be able to pick the relevant product and also the price in the cell next to it. I can create a drop down box for the product list - no problem - but I cannot find a way of also bring in the selling price.

Expert:  Richard replied 2 years ago.
Can I look at your sheet please Graham? Its easier for me.
- Click the following link: http://www.wikisend.com
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"
Customer: replied 2 years ago.

I scrapped the sheet as I wasn't making progress with the view to starting again.

Expert:  Richard replied 2 years ago.
You want me to put together something for you?
But, before we start, do you have Microsoft Access there Graham?
As a invoicing system belongs better in this, as Excel can do it but is not made for it whereabouts Access is.
It comes with Office professional, let me know.
Customer: replied 2 years ago.

I have it but am not familiar with it.

Expert:  Richard replied 2 years ago.
ok, I can make you this in Access which is in the long term better for reports, expansion ect.
Or in Excel
Let me know please.
Customer: replied 2 years ago.

excel as I have a better understanding of it.

Expert:  Richard replied 2 years ago.
no problem, doing it now
Customer: replied 2 years ago.

Thank you

Expert:  Richard replied 2 years ago.
Your welcome, nearly done
Expert:  Richard replied 2 years ago.
This is now done Graham
Go to www.wikisend.com and download from File ID 420894
You will see page one you add the product and price and on the next sheet you can select it and it will link the price.
Let me know the results please
Customer: replied 2 years ago.

Thank you. I am obviously missing something. The dropdown box doesn't seem to work.

Expert:  Richard replied 2 years ago.
I redownloaded it and it works perfectly here Graham.
How does it not work for you?
I can see you are a first time user to the site. What we do here is either a question and answer type of conversation or remote support where I would actually connect to the computer and have a look and fix the issue if possible.
Remote support can save a lot of time if you are not comfortable performing repairs yourself.
I will send an offer through for remote support and should you accept I will connect and see what is going on and fix the issue. Otherwise we can continue to talk like this but I will need to ask a number of other questions and try and walk you through some steps for repair.
Both options are 100% guaranteed by the way. Remote is just quicker and avoids the risk of you making a mistake and doing something wrong.
If you want remote click get extra help. If not simply reply to me.
Thanks,
Richard
Customer: replied 2 years ago.

I'll take another look at it and try an understand why it's not working. I'll get back to you later.

Expert:  Richard replied 2 years ago.
ok, open the sheet, then you just click and choose a value and next to it you will see the price appear.
Let me know the results please
Customer: replied 2 years ago.

Hi. No. There is the word apple in the dropdown box but it can't be changed to any of the other items in the inventory. Also I need to have multiple product on the invoice. I think I can manage that but the first issue is still not resolved. Your help is appreciated.

Expert:  Richard replied 2 years ago.
ok, it is working perfectly for me so I am really confuse why you have the problem.
Can I log on and look please on the connected computer?
It is easier to work with you on this. You can see and control everything I do
Can you please go to www.teamviewer.com
Click on Download in the top right.
Go down to "TeamViewer Quicksupport"
Click on Download and download and run the program.
It will give you an ID and a Password.
Please give me the ID (leave a space between each character eg: 1 2 3 4 5 6 7 8 9) and the password ***** your next message to me here.
Do not close the program, but leave it open.
I can then connect to your computer.
Thank you
Customer: replied 2 years ago.

902 833 766

4803

Expert:  Richard replied 2 years ago.
Thank you
Customer: replied 2 years ago.

That seems to be Ok now. Only thing I need now is how do I increase the nuber of lines for the invoice. Thanks so much for your help

Expert:  Richard replied 2 years ago.
Your most welcome
was an error in excel causing the problem, which we fixed as well Graham.
If you would like any additional information or assistance, please do not hesitate to let me know.
And if you can take a second to rate my service, that would be greatly appreciated.
Thank you
Richard, Computer Support Specialist
Category: Computer
Satisfied Customers: 35380
Experience: Over 15 years of consulting to the IT industry
Richard and 2 other Computer Specialists are ready to help you
Expert:  Richard replied 2 years ago.
Sorry Graham, where you asking me this?
I may have misread it

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 Customer
< Previous | Next >
  • 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 Customer
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • 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!!!! Alex
  • 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. GP
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
  • 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. Esther
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
 
 
 

Meet The Experts:

 
 
 
  • Kamil Anwar

    Kamil Anwar

    Computer Support Specialist

    Satisfied Customers:

    161
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
< Previous | Next >
  • http://ww2.justanswer.co.uk/uploads/JA/JACUSTOMERf8udkdxk/2013-8-3_15150_323738101505074393259301621172992o.64x64.jpg Kamil Anwar's Avatar

    Kamil Anwar

    Computer Support Specialist

    Satisfied Customers:

    161
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
  • http://ww2.justanswer.co.uk/uploads/WI/Windowspcfix/2013-8-19_153826_ja12.64x64.jpg James K.'s Avatar

    James K.

    Consultant

    Satisfied Customers:

    93
    Technical Director of IT Company
  • http://ww2.justanswer.co.uk/uploads/JO/JonTech/2011-10-25_111835_A2c.64x64.jpg Jon-Tech's Avatar

    Jon-Tech

    IS Manager

    Satisfied Customers:

    61
    20 yrs: Computers, Networking
  • http://ww2.justanswer.co.uk/uploads/JA/jamieratliff/2012-2-8_194551_jamie.64x64.jpg jamieratliff's Avatar

    jamieratliff

    Information Systems Manager

    Satisfied Customers:

    21
    Jamie has worked in the Information Technology field for over a decade.
  • http://ww2.justanswer.co.uk/uploads/JA/JACUSTOMERleg4q7o8/2012-3-6_203036_meja.64x64.png TheDoctor's Avatar

    TheDoctor

    Software Engineer

    Satisfied Customers:

    16
    Experienced Software Engineer
  • http://ww2.justanswer.co.uk/uploads/FI/FisherEngineering/2012-1-18_194422_Fisher375Headshotcompressed239K.64x64.jpg Bill Fisher's Avatar

    Bill Fisher

    Computer Engineer

    Satisfied Customers:

    1
    Computer system design, networks, integration, general support.
  • http://ww2.justanswer.co.uk/uploads/ZE/zeyank/2014-12-9_221254_zeyank.64x64.png Ryan H.'s Avatar

    Ryan H.

    Computer Support Specialist

    Satisfied Customers:

    1739
    A+ Certified Technician - 10 Years experience working with all types of computer systems.