Hello to all,
I've workbook with list of clients, containing multiple sheets. I want to find and print a list of clients, based on some conditions - in my case column ""Product"" & ""Type"".
In the attached example:
in sheet ""Search"", Green and Blue cells are the Criteria, in the table below i want to display the results - in this case all the clients with product ""trousers"" and type ""man"".
Looked through VLOOKUP formula, but i think it can't result me all the cells for the client including firm, addres, person and so on.
Should i use macro in this case?
And the second question, if i don't have to use macro, how can i cleanup the workbook, because now there's left some code and even i haven't macros in the book, it asks me when i open it, to enable or disable macros...
I appreciate any help,
thank in advance.
Bookmarks