In the attached spreadsheet I have a sheet that has in it, a table for the data to be imported into as well as 4 different search criteria (This will be about 15-20 on the actual spreadsheet but the others were removed as they are sensitive. What I would like is code that will check all 20 to see if they are being searched for. (i.e. If team says K and exact match is No then it will search for all teams with a K).
As a second point I would like any fields that have a no in the 'search for?' column to not be included in the import column. (Headers won't be displayed in the spreadsheet until import, I have just left them there so you know what the headers are.)
The code that I am using at the moment doesn't incoroprate the second point at all as I can't work out for the life of me how this can be done. The code in the spreadsheet will search by the top criteria on the spreeadsheet as it stands.
I would ideally like to understand how this is all done rather than just receive code but I will take anything at the moment!![]()
Please Login or Register to view this content.
Thanks for any help.
Bookmarks