February 22, 2020
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.
October 5, 2010