Hello,

I'm trying to create a tool to auto populate a form from data in a log on Sheet1 to a Form on Sheet2.

Steps I would like to take:
1) Press "Transfer" button
2) Enter Transfer number
3) Form populates with all the values found for that transfer number. Even multi rows if the number appears multiple times.

I've created a sample Workbook of the general layout.

Thanks in advance!

Attached Files

Sample Macro.xlsm (20.2 KB, 12 views)