Creating Dynamic Ranges of Cells from Various Sheets
I currently have a master sheet that has all my jobs in a single sheet in order to consolidate all the data I'm saving from these projects.
Each project has an estimate that is a stand alone sheet named by the Job name. This job name is stored in the master job sheet. There are some specific cells I want to bring in from each estimate sheet in order to load them into the master job sheet.
Unfortunately I don't want to manually link each sheet, so I am looking for a formula to dynamically call specific cells or range of cells from different sheets with a standard naming scheme that is held on that master job sheet.
Thanks,
Best Answer
-
To add on to @Bassam.M Khalil's good suggestion, if you need help building out these cross-sheet formulas, it would be helpful to see a screen capture of each sheet (with the sensitive data blocked out, or a dummy sheet with the same columns instead).
If you could provide this, along with detailing exactly what you want to be brought across, the Community would be happy to help! It may be an INDEX(MATCH formula, or INDEX(COLLECT (see this post) or it could be a JOIN(COLLECT (see this post), depending on the data you're looking to retrieve.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hope you are fine, you can do that by using one of the following functions ( Vlookup, Index with Match )
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
To add on to @Bassam.M Khalil's good suggestion, if you need help building out these cross-sheet formulas, it would be helpful to see a screen capture of each sheet (with the sensitive data blocked out, or a dummy sheet with the same columns instead).
If you could provide this, along with detailing exactly what you want to be brought across, the Community would be happy to help! It may be an INDEX(MATCH formula, or INDEX(COLLECT (see this post) or it could be a JOIN(COLLECT (see this post), depending on the data you're looking to retrieve.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!