Macro to query data based on a criteria sheet

[kayoke]

Help needed!!

I've a macro to query data using a criteria sheet (SearchEngine). Data is constantly updated in the Database. However, my query sheet is only able to return search only when the "Name" column (A) is not empty. When an employee has more than 1 row of data, the macro no longer functions as intended.

E.g. Employee A (A8) can be working in both Singapore and Indonesia. Since it is detail for the same employee, I left the cell A9 empty. When i query Employee A in SearchEngine (D8), it only returns the row A8:H8 and not A9:H9.

[arlu1201]

Since it is detail for the same employee, I left the cell A9 empty.

This is the answer to your question. The way you have the data setup, you have to fill in A9.

I like your file. Its a very neat database.

I have just got rid of all the select statements that you have there and re-attached your file here. Just have a look.

[kayoke]

Thank you.

But is there another way to do it without inserting A9? Cause it is pretty weird for employee database to have repeated names again and again.

An alternative way that I thought of is to have the repeated names yellow in colour (same colour as the background) so that it is not visible. Are you able to make a macro for it?


kayyoke

[kayoke]

Eh, sorry..Wrong. Should be white in colour >_< because this query paste the values in the SearchResult and the SearchResult background is white in colour.

[kayoke]

I've found the answer.

[arlu1201]

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[kayoke]

To interested viewers: Here is the extra code for changing the font to white (code no. for white = 2)

Please Login or Register  to view this content.