i200yrs
New Member
- Joined
- Dec 18, 2019
- Messages
- 43
- Office Version
- 2019
- 2016
- 2013
- 2011
- 2010
- Platform
- Windows
Hello Excel Experts...need some help...see table below:
A B
1 Apple
2 Ball
3 Apple
4 Cat
5 Dog
I want an excel macro like if the user key-in "Apple" and click search will return values from column-A and list it in Column-C.
Like below result:
C
1
3
Hoping for usual supports...thanks
A B
1 Apple
2 Ball
3 Apple
4 Cat
5 Dog
I want an excel macro like if the user key-in "Apple" and click search will return values from column-A and list it in Column-C.
Like below result:
C
1
3
Hoping for usual supports...thanks