Excel Tutorial - Use FORMULAS across worksheets

Use formulas to calculate values across worksheets and workbook in Microsoft Excel and increase your productivity. Explore the full course and discover more powerful Excel tools: www.linkedin.com/learning/exc...
Dennis Taylor, an Excel expert, has 25+ years of experience in spreadsheet authoring and training.
#Excel
#HowTo
#LinkedIn

[@drewt.4353]

Thank you, that gets me closer to my goal. I wanted to pick and choose sheets from the same book. The sheets will not be all lined up in a row, but skipping every 3.

[@philipmunkhondya9813]

Thanks bro, you just made my work easier

[@MakeWay4CJ]

I was trying to figure out why I never had this problem with spacing between words and found that it was because I was taught in school to use an underscore between the words. That way you can still have a visual space between the words while not letting it get in the way of the formula. I think if you try that, you could then successfully use the INDIRECT function without having to go through as much. Just a thought.

[@frannieingram4191]

Pppppp

[@mattylubach2080]

THANK YOU BRO

[@wylergiordani7210]

This was amazing, but can you provide a video on how you would do this if the tables were not aligned? Or if the information you’re looking for is in a different row? Is there a way to use a index match across worksheets?

[@jayden7877]

Agree

[@colleenclark5651]

Thank you!!! I watched other videos and read several articles and none of them were as logical as your tutorial. You saved my day!

[@samuelfletcher8246]

POV: you missclicked

[@Destiny-fz3id]

Omg yes

[@Yogurto_the_first]

YES

[@kiortooprblx]

Omg YES😭😭🤣🤣

[@sansheh]

Yes I was on a different video and hit this on accident

[@oliviagrace6914]

For God so loved the world that he gave his one and only Son, that whoever believes in him shall not perish but have eternal life. John 3:16

[@bagchasinmar3172]

Amen 🙏🏾

[@thatdogecolt9871]

I miss click

[@jayden7877]

Agree

[@melroseortega5399]

Do it! Total recall call me!

[@kobegraves6243]

Cf

[@ericjohnson6653]

1080 juat killed you

[@Mahadev.fan1]

Hindi bol le chacha