Gopal's voice itself is soothing and garners confidence into the minds of viewers. Besides, he explains patiently in a language which has clarity and simplicity. I benefited hugely.
You are the first person I have found that I can actually listen to and understand what is going on. I have very basic knowledge of Excel but am learning all the time. I have a problem that I can't find an answer for. I keep the records for a Golf society. I have a Master record (Workbook)of all players with Handicap information (Sheet 1). I have a record of all players that have paid plus other information (Sheet 2), I have another record of all competitions per member (Sheet 3). All Sheets contain the same information - Surname, Name, Handicap. My problem is that not all player information is in the same place (Row) on each sheet. During a season the only thing that changes is the Handicap. I want to be able to go to Sheet 1, select the player and change the handicap and this will change on all sheets automatically. I cannot find a way to do this. I am hoping you can help in this regard
This was a great tutorial. I would like know how I can update the tab name and have it updated in the table of content automatically. Can you make tutorial of that please? Thank you!
can you do a tutorial on how to link the inserted image in different worksheet? then if you change the inserted image, all the images with the same image that linked to the inserted image will also change in different worksheet at the same time.
I'm working on a table of contents with hyperlinks to the actual form or procedure etc. because it is quite a size. I have inserted a search box with filters that data by section or what ever search criteria the staff enter. The problem is the links in the source data does not come over top the destinations cell
Absolutely brilliant tutorial without the like, share, and subscribe crap. Can you please do an interactive dashboard for dummies like me? Thank you sir
If I make an Invoice tracking sheet with a column of diffent customers who need invoicing, can I use an invoice number that when clicked will open up an invoice with that clicked invoice number populated on the sheet. I can't figure out a way that excel would do this each time I invoice a customer.
Link to Complete Excel Foundation Course : shop.presentation-process.com/p/complete-excel-foundation-course
Gopal's voice itself is soothing and garners confidence into the minds of viewers. Besides, he explains patiently in a language which has clarity and simplicity. I benefited hugely.
Wooow!! Thanks alot!, Have been longing to know, how to link two sheets without, Clicking...., God do you Good,,,,
The way you explain is superb sir.
Thanks and welcome
I finally found how to hyperlink two cells in diffent sheets but in the same Excel folder. Thank you
Straight forward and simple... Thankyou!
The best tutorial on this topic. Definitely subscribing to your channel. 🥃
Your explanation was very effective, thank you
Thanking You Sir ^___________^ it works up to this day like magic ^___^ straight to the point
Thank you so much. All info, no fluff. Exactly what I needed
Thanks for your explanation for this lesson. Now I can do it. I hope you will make a new video.
You are a life saver my dude, Keep this channel going, please!
Thank you sir its is help full to us
Thank you! You explained it very well and it helped me
Glad to hear that!
Simple and perfect presentation to make someone understand
I've learned a lot sir, I realized that MS excel is a powerful office
I just want to call you "Excel Angel" right now!!!
Very helpful, Thank you!
Glad it was helpful!
You are the first person I have found that I can actually listen to and understand what is going on. I have very basic knowledge of Excel but am learning all the time.
I have a problem that I can't find an answer for. I keep the records for a Golf society. I have a Master record (Workbook)of all players with Handicap information (Sheet 1). I have a record of all players that have paid plus other information (Sheet 2), I have another record of all competitions per member (Sheet 3). All Sheets contain the same information - Surname, Name, Handicap.
My problem is that not all player information is in the same place (Row) on each sheet. During a season the only thing that changes is the Handicap.
I want to be able to go to Sheet 1, select the player and change the handicap and this will change on all sheets automatically. I cannot find a way to do this.
I am hoping you can help in this regard
OMG this video is very simple yet very helpful. Thank you very much
Ma Shaa Allah Thanks brother
this is what I exactly looking for
Thank you sooooo much. It was very easy to understand. And the shortcut is very much useful. It helps in doing it it faster than making formulas
Thank you, very useful, I needed this.
Thanks for the video ....got easy solution
This was Very Helpful to me. Thanks Gopal!
Nice.
I could understand in one go.
😌
Brilliant video you make a tricky technique look easy
Clearly explained. Good.
This was a great tutorial. I would like know how I can update the tab name and have it updated in the table of content automatically. Can you make tutorial of that please? Thank you!
This was super helpful! Thank you!!
Very very useful, thank you...
Thank you.. Thank you.. Thank you.. Thank you.. Thank you.. Thank you.. Thank you.. Thank you..
You got a new subscriber
This was very helpful. Thank you!
Thank you Sir, very well explained. Exactly what I needed.
Brilliant demo, thank you...
Thank you, super helpful!
Excellent presentation very easy to follow.
i solved my problem through your video, Thank you.
Thank you very much. your instruction was amazing, fast and very eazy to understand.
thanks you sir i am easly understanding .
Thank you, How to share it, the link setting will remain the same or changed.
Excellent video!! Thank you for sharing.
You saved my life
Great help. Simple steps make easy to understand the whole concept. THANK YOU!!!
Amazing! Easy and concise information
Loved the presentation, clear and concise that's very easy to understand
Excellent explanation. Many thanks
Great help. Thanks
thank you sir very helpful
Thanks you very helpful 🇰🇼♥️
It's amazing 😍🤩
Just what I needed, thank you!
Thank you. Very helpful for me.
Wonderful and understood
Learnt what I needed. Thank you.
Thank you
So helpful
can you do a tutorial on how to link the inserted image in different worksheet? then if you change the inserted image, all the images with the same image that linked to the inserted image will also change in different worksheet at the same time.
Thanks a lot Sir! 😊
Most welcome!
Thank you for your help
chose the first method.. Thanks so much
Thnx alot..very clear and easy to understand..👍
I have subscribed sir...u r a cool guru
excellent video. Thanks!!!
Very helpful...thanks a lot!
It is very good video. Thanks for the help.
Perfect explanation
Thank you its working
Thank you
You're welcome
Well explained. Thank you
can use the same method to hyperlink excel tabs in PowerPoint
thank you very much
Thank you so much..
🙏🙏
I want to know how to add hyperlink from different excel cells
Amazing n bestest👌
I'm working on a table of contents with hyperlinks to the actual form or procedure etc. because it is quite a size. I have inserted a search box with filters that data by section or what ever search criteria the staff enter. The problem is the links in the source data does not come over top the destinations cell
Thankyou sir finally found
Superb
Suuuuuuuuuuuppppppeeeeeerrrrr 👌👍👍👍👍👍 thanks a lot
Do these same steps work for two different spreadsheets on a network drive?
Great tutorial
This is exactly what I am looking for
NICE TECHNIC
Very useful session. Thank you
Impressive
good job
I was wondering if there was a way to have your hyperlink go to the last location your curser was on the sheet, instead of a specific cell.
Really helpful, thank you.
Absolutely brilliant tutorial without the like, share, and subscribe crap.
Can you please do an interactive dashboard for dummies like me?
Thank you sir
Great thank you (Y)
thsnks buddy
Thank you for making the video..it was a big help!
Cool video
Thank you so much sir its works
P H E N O M E N A L ! THANK YOU
Thank you!
If I make an Invoice tracking sheet with a column of diffent customers who need invoicing, can I use an invoice number that when clicked will open up an invoice with that clicked invoice number populated on the sheet. I can't figure out a way that excel would do this each time I invoice a customer.
Can vlookup return a hyperlink that connect to specific range in another sheet or workbook ? How do you enable that ? Thanks
Helped a lot, thanks!