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

I want to copy sheet 1 to sheet 2 and 3. How do I do to make

This answer was rated:

I want to copy sheet 1 to sheet 2 and 3.
How do I do to make sheet 1 the master and automatically get all changes in this master sheeet transferred to the the other sheets?
Hi there and welcome

Can you tell me which program and version of it you are using?

Thank you
Customer: replied 3 years ago.

MS Excel 2010

Thank you

You need to put this in the cells of the other sheets so they reference the master sheet (and obtain its values).

For the example I am assuming that the name of master sheet is master

Then in other sheets you will put in the cell that you want to display from the master sheet


This would than display the value of the cell A1 from the Master sheet.

Please let me know if this is what you require to achieve your results, else if possible, please provide a little more information.

Thank you
Richard and 2 other Microsoft Office Specialists are ready to help you