I know this is probably covered somewhere else, so bear with me please. . . . or just don't answer this and link me somewhere else. . . .
I have nice ~4000 row database with information. Each row can be identified by a text code. Say some jerk in another department wants me to find 100 rows of data based on these 100 text codes. The text codes are totally random, so you need a way to filter to just get that data.
I know to use Excel's advanced filter capabilities you need to have the cells in this format ="TEXTCODE" I also know its a pain in the rear end (if not impossible?) to insert quotation marks using a simple macro into a text string -- since Macros use the quotation marks to define the text string.
So is advanced filter not the way to go about this??? Or Macro, or. . . .well I don't really know.
Much obliged for the help and have a good weekend. .. ..
I have nice ~4000 row database with information. Each row can be identified by a text code. Say some jerk in another department wants me to find 100 rows of data based on these 100 text codes. The text codes are totally random, so you need a way to filter to just get that data.
I know to use Excel's advanced filter capabilities you need to have the cells in this format ="TEXTCODE" I also know its a pain in the rear end (if not impossible?) to insert quotation marks using a simple macro into a text string -- since Macros use the quotation marks to define the text string.
So is advanced filter not the way to go about this??? Or Macro, or. . . .well I don't really know.
Much obliged for the help and have a good weekend. .. ..