Forum Discussion

SenpaiYoshi's avatar
SenpaiYoshi
Copper Contributor
Feb 05, 2019

Trying to automate a spreadsheet based on Column A

So essentially what I am trying to set up, is something for my robotics team, what I am struggling to do is essentially make it so if A2 says, for example, The Cheesy Poof, it would go to the corresponding tab called The Cheesy Poof, and then pull data from that tab and run it through that function (so average, or countif, etc) . Each different row would run different data from different Tabs, based upon what Column A Row X says.

 

Here, an example spreadsheet to show what I am trying to do:

 

Thank you so much!

Resources