Hello,
i am working a side project try to organize football stats. i have a drop down list that consists of 12 positions and i have 12 work sheets, each one being a different position. i am trying to get it so that when i would choose a position from the drop and maybe click a "retrieve Button", it will grab all data from the corresponding tab. if i choose another position it will overwrite the current data and show new data. i was going to create a macro or even make a master list and use vlookup but i was just seeing if there was some code to do this in place of the tendious work? maybe this could be an access thing if it is easier but i am not familiar with access yet. i will gladly share my workbook for anyone interested, i am learning VB codfing for work and thought that could be some side practice.
Thank you all(huge resource in learning!btw)
-Lyn5339
i am working a side project try to organize football stats. i have a drop down list that consists of 12 positions and i have 12 work sheets, each one being a different position. i am trying to get it so that when i would choose a position from the drop and maybe click a "retrieve Button", it will grab all data from the corresponding tab. if i choose another position it will overwrite the current data and show new data. i was going to create a macro or even make a master list and use vlookup but i was just seeing if there was some code to do this in place of the tendious work? maybe this could be an access thing if it is easier but i am not familiar with access yet. i will gladly share my workbook for anyone interested, i am learning VB codfing for work and thought that could be some side practice.
Thank you all(huge resource in learning!btw)
-Lyn5339
