Log In
Register
Home
Active Member
February 22, 2020
Offline
When I read the recent newsletter that showcased ‘searching for data with a user form’, it got me to thinking how I might be able to apply this to the data that I have.
Essentially, I have cricket records for the current season that I have listed in seven sheets within a single workbook. Each sheet refers to different competition types but are identical in layout and content. Players names are on the same row as are their individual figures, matches played runs scored and so on. There is no manual input on any sheet as I use data links from another workbook(s). My question is, could a user form and the code behind it find and fill fields in the user form from all seven sheets/tables so that by entering one record number (or player’s name) all data from all seven competitions will populate?
I've attached a sample workbook.
Thanks for your guidance.
Mel
October 5, 2010
Offline
Hi Mel,
You could do this with VLOOKUP or XLOOKUP and avoid having to create a form and write VBA to make the form work.
Create a new sheet and create the appropriate formulae to lookup the data you need.
You could use a data validation list to choose the player name.
Regards
Phil
1 Guest(s)
