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
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
Thanks, Phil,
I'll do some more research!
Mel
