How to Automatically Update Data in Another Sheet

How to Automatically Update Data in Another Sheet

The following will help to understand the steps on how to automatically update the data in another sheet.

If you are in a rush and want your problem answered, email to exploresarcs@gmail.com or live chat with us.

There are various procedures. However, please refer to the following quick procedures.

  1. Enter any value in sheet1. Select sheet2, and press “=”. Then, select the cell containing value in sheet1.
    • Ex: sheet1!B1
  2. Copy the cell containing data using ctrl+C. Select sheet2, right click on the cell and click on paste speical > Links.
    • Ex: sheet1!$B$1

If there are more cell to update, preference will be given to Excel VBA. SARCS is good at creating VBA Macros for the data updation.

https://www.quora.com/How-can-I-automatically-update-the-data-from-sheet-1-to-sheet-2

www.got-it.ai/solutions/excel-chat/excel-tutorial/data-entry/automatically-update-data-in-another-sheet

About the author: admin

You must be logged in to post a comment.