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, Software Specialist
Category: Microsoft Office
Satisfied Customers: 31332
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I'm using excel.I have a list of data that depending on what

Customer Question

I'm using excel.
I have a list of data that depending on what the first two numbers are the following 8 numbers are decoded very differently 15 different ways.
Can I have a second sheet with the 15 formulas x 8 cells listed and invoke them from the first page?
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Richard replied 1 year 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.
You can reference the second sheet from the first one, but you cannot invoke the formula remotely.
The formula must always be in the cell it wishes to display the data on.
Or you would do it via the VBA (programming) within Excel.
But on the sheet itself it cannot be invoked remotley
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 by clicking one of the stars at the top of the screen or smiley faces, that would be greatly appreciated.
Thank you