Lookup query?

[hunkymonkey]

I have a spreadsheet containing a list if projects. The projects are
detailed by row and there are 20 columns for each project, each column
detailing a different piece of information on that project. One of
those columns advises the project manager's name ("Bob", "Pete",
"Dave") or whether it is cancelled ("cancelled"). On a separate
worksheet within the same file I want to detail all the cancelled
projects (one in each row) and show column 6 (name of project), 10
(project number), 13 (budget) and 18 (what happened) of each cancelled
project. Is this possible in excel or am I looking at Access to pull
that off for me?

Any thoughts my friends?

 

[Biff]

Hi!

How many rows of data are there?

You could use AutoFilter and filter on "cancelled" then copy/paste. Not
dynamic but it's easy.

Biff

"hunkymonkey" <[email protected]>
wrote in message
news:[email protected]...