outlawspeeder
Board Regular
- Joined
- Jan 17, 2009
- Messages
- 223
- Office Version
- 2019
Column A has a 1st name and Column B has a last name.
What Im looking to do is from a list table, have users enter enter 1st names, then press a button and have all rows with the same last name copy to another worksheet.
I just don't know how to get vba to set a varable from a column search and a follow on search.
What Im looking to do is from a list table, have users enter enter 1st names, then press a button and have all rows with the same last name copy to another worksheet.
I just don't know how to get vba to set a varable from a column search and a follow on search.
