Basically there is no shortcut in your case, unless you write some script (VB script) for the excel, or you may use simple worksheet name, such as "1" instead of using "Pricing" for simpler commanding. It is recommended to use Microsoft Access or other database programmes if you need 200 worksheets.
Will this work if the titles of your sheets have spaces? For example, will sheet title "Expenditure Sheet" be allowable for typing in a cell in sheet "Expenditure Chart"?
What is this doesn't work? Also what if you want to reference a cell but that cell contains a formula? I don't want to reference the formula. I just want to reference whatever that cell says but I can't
no talking. just work! great
7 years ago and still helpful to this day, thank you
Thanks for your support 🙏🏼🙏🏼
concise and to the point, thank you
You're welcome!
Hey thanks man, saved me a lot of time with this! You're the best!
Thank you for your useful and informative video.
Nice, thanks its very helpful, keep on making tutorials we appreciate it.
Sure thing! thank you for your support!
This was helpful, thank you.
Hello,
When I have 200 sheets in a single excel work book then any shortcut is available?
Basically there is no shortcut in your case, unless you write some script (VB script) for the excel, or you may use simple worksheet name, such as "1" instead of using "Pricing" for simpler commanding. It is recommended to use Microsoft Access or other database programmes if you need 200 worksheets.
Will this work if the titles of your sheets have spaces? For example, will sheet title "Expenditure Sheet" be allowable for typing in a cell in sheet "Expenditure Chart"?
If the name contains spaces wrap the sheet name in single quotes e.g 'Expenditure Sheet'!A1
Thanks a lot.. 🎉
Thank you so much
How to use drag... suppose I want to refer B17 from 50 sheets... and have a distribution?
Use VBA code instead. It will take a lot of time to refer it manually one by one.
What if we want to merge two cell values in one cell?
Use Merge Cell function
Tnx bro
What is this doesn't work?
Also what if you want to reference a cell but that cell contains a formula?
I don't want to reference the formula. I just want to reference whatever that cell says but I can't