How to get data from another sheet in Excel

By | May 4, 2020


How to get data from another sheet in Excel


Microsoft Excel is a spreedsheets  -based application  that is commonly used in financial jobs where Ms. application. Excel will make it easier for users to process numbers (Math), this application provides a lot of formulas that you can find formula information on the Internet or on the official site of Microsoft Excel.

On Microsoft Excel worksheets it has  subpages  or sub-worksheets where you can have more than 1  subpage  in 1  excel file  , this of course is provided by Microsoft (the creator of the Microsoft Excel application) which aims to facilitate the users in processing data very much,  The intended subpage  is called a  sheet  in the Ms Excel application.

Examples of data processing that the author intends above for example such as taking data in  another sheet  on your worksheet, the following way.

1. You create a new worksheet or you can continue your worksheet

2. Make sure that in your excel worksheet you have more than 1  sheet

3. Then you make sure you know the position of the  cells  or the position of the columns and rows in the data in a  sheet  that you want to retrieve, for example in the picture below where the  cells are  B3

4. Then you open  another sheet  , you type in the  cells  you want, you type

= sheet! cells

Example: in the case above where the data to be retrieved is in  sheet  Sheet1  and the  cells  on  Sheet1  are  B3 , then you can just type it like

= Sheet1! B3

5. So when you click  enter  on the  keyboard the  text will change according to the data you want to retrieve

Done.

Note: You can use other formulas that you know and combine with the formula above, when the data at the source is changed, then the data from the recipient will also change according to the source. If you do not want the data at the recipient to not change due to changes in data at the source, you should  just copy and paste the  data manually.


Leave a Reply

Your email address will not be published.