Extracting Data from a Database, but skipping rows

[jppe]

This is my first post here so hi everybody...

The situation is this:
I have tables in different files, the main one is used to creat
projects and assign a person who will be in charge, among othe
information, the other tables are used by some people to fill in th
hours dedicated to each project assigned to them.
For example (Main Table):
Project A, Responsible John
Project B, Responsible Bob
Project C, Responsible Mary
Project C, Responsible Bob
Project D, Responsible Mark
Project E, Responsible John

What I need to do is to find some way to update the dependent tables s
that when I create a new project in the main one and assign a person i
charge, automatically that line is created in that person's file, bu
without skipping rows, like a simple link would do. In the exampl
above, John's file would have 2 rows, like Bob's file, and Mary an
Mark's file would have just 1 row.
I've tried to do this with de Database extracting formulas, but the
only get 1 record, not every record that match some criteria.
I hope I've explained myself, but please let me now if you need som
more detail. I've included an image file to explain better.

I need this kinda urgent, like tomorrow...
Thank you all very much for any help you can provide.

Excel Version I'm using:
Microsoft Excel 2000 9.0.3821 SR-1 on Windows XP SR1

Juan Pabl

Attachment filename: post.gif
Download attachment: http://www.excelforum.com/attachment.php?postid=57288

 

[Frank Kabel]

Hi
just as a question: Why don't you use 'Data - Filter' for simply
showing only the relevant part of your main table. Otherwise for this
kind of application I would use a database application and not excel

 

[jppe]

I wanted to do it in MSAccess, but it is not installed on every P
because they have no lincences, so I had to do it in Excel.
I kinda found a way to do it, although I don't know (actually I reall
don't think) it's the best way. Here is what I did:
On the main table, I created as many worksheets as the number of users
one for each.
Then I created a macro that filters the data by responsible, and the
copies everything to the corresponding worksheet. This latter is the
linked to the other file of the user, where he only sees the project
in which he is involved.
I have to restrain myself from thinking how much easier it is to do i
in Access, but that's the way it goes...
Please let me know if you come across a better solution.
Th

 

[Frank Kabel]

Hi
in Excel I don't think there is a really better solution for this