pivotguy
04-07-2016, 05:38 PM
I have 4 tabs in excel spreadsheet
Output (13 Records)
Show (search Button): VBA code attached and working fine.
Requirement
List of Values
The idea is to display data from “Output” sheet based onsearch criteria (Zip Code) and display in “Show” sheet. I have written a VBAcode on “SEARCH” button and data is perfectly populated in “SHOW” sheet. No Issue.
Currently data can only search by Zip code. I would like to search by territory, first name, last name, region and name ‘wild card” search etc. See the “requirement” dropdown values sheet.
Any suggestion how to enhance the VBA code?
Output (13 Records)
Show (search Button): VBA code attached and working fine.
Requirement
List of Values
The idea is to display data from “Output” sheet based onsearch criteria (Zip Code) and display in “Show” sheet. I have written a VBAcode on “SEARCH” button and data is perfectly populated in “SHOW” sheet. No Issue.
Currently data can only search by Zip code. I would like to search by territory, first name, last name, region and name ‘wild card” search etc. See the “requirement” dropdown values sheet.
Any suggestion how to enhance the VBA code?