Let’s learn how to link from one sheet
to another sheet in Microsoft Excel. Hello guys, what’s up?
This is Chogyal from the channel Sir Chogyal. If you are new to me, please
consider subscribing. In this sheet1, let’s say we have the weekly
expenditures for the month of January. This is the total price incurred during
the first week. Let’s link this total price to another sheet, that’s sheet2. We can see
here the total price of the first week is at Column B and row 7. We are going to
link this total amount to sheet2 . Now go to sheet2. Type here=sheet1!b7 and hit enter on your keyboard or just type your=and go to sheet1 now left-click on the number that you want to link and hit
enter on your keyboard. We can see here the function has automatically generated.
Linking from one sheet to another sheet is very easy. Just type=and
you go to a sheet. Then left-click on a value that you want to link and hit
enter on your keyboard. That’s it guys! Thanks for watching and
goodbye until next time.