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, Software Engineer
Category: Software
Satisfied Customers: 44582
Experience:  Software Systems Specialist.
Type Your Software Question Here...
Richard is online now

Using the current Excel I have a one sheet that is a Summary

This answer was rated:

Using the current Excel I have a one sheet that is a Summary sheet. I want to make it automatically insert values from specific cells in the other sheets. How do I do that?
Thank you for your question, my name is ***** ***** I look forward to assisting you.
Please note, a rating is only needed when we are finished.
normally you would use a vlookup for this.
So along the lines of
=vlookup(what to match, where to search, which number column to return)
If you do the below to provide me your sheet, I can check it and do this for you to show you
- Click the following link:
- 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. what to I type into the summary page cell?
Did you see my last message?
I would need to look at your sheet to know this...
Can you provide it to me as requested please?
Customer: replied 2 years ago.
They data is confidential and I don't want to share it with anyone.
All I want to do it take the value from one cell on another sheet in the same workbook, which has a name, and show the same amount (number) in the relevant cell in he summary sheet. I am not IT knowledgeable.
ok, you can use this formula id thats all you want to do
With Sheet2 being the sheet name and the cell being B9
You would change this to reference your sheet and cell in your file.
Let me know how you go please.
Richard and 2 other Software Specialists are ready to help you
Customer: replied 2 years ago.
That's it. Thanks!
your welcome!
If you need anything else please let me know
Thank you