Brilliant and simple idea .. YES. This will make my life much easier.
Thanks a million, Biff.
Tendresse

"T. Valko" wrote:

You could add 2 columns to your table on sheet2 that lookup the branch name
and address from the table on sheet1 and then just filter the table on
sheet2 by position.

Here's a small sample file that demonstrates this:

delete1.xls 19kb

http://cjoint.com/?iFiiRHFTwy

--
Biff
Microsoft Excel MVP


"Tendresse" wrote in message
...
Hi all, I desperately need help.
I'm in the process of creating a large database for our office. Due to
bureaucratic reasons, my employer will not be able to install Microsoft
Access on our computers, and I was told to use Excel instead! For the last
couple of days i have been like someone trying to use a screw driver as
hammer! I know Excel is not the best tool for that job but i have no
choice
but to try to go around things. I hope that someone in the community would
be
able to help me with one particular problem.

In the first worksheet, i have a table of our offices (branches) details,
as
follows:
A B C D E
Branch Branch
ID# Name Address Phone Country .... etc

In the second worksheet, i have a table of employees (Emp.), as follows:
A B C D E
Emp. Emp.
ID# Name Position Salary Branch ID# .. etc

(Notice that column E in table 2 is the Branch ID#, which is the same as
Column A in table 1).

Now, out of these 2 tables, how can i get a list of:
All EMPLOYEES who have a certain POSITION (eg. supervisors) and their
correspondent BRANCH NAME and BRANCH ADDRESS.

Is this sort of queries possible in Excel 2003? Can this be achieved
through
filtering, pivottables or VBA?
Any help would be greatly appreciated.

Tendresse