cretae a sheet of selected rows

T

Theo Brandt

apologies, forgot to complete subject before hitting go!:

Hi there.
I have a sheet 'events' with 'A' Row being a patient ID taking the
form S002, S003 etc. Each patient can have more than one row- these
are hospital events, so often more than one.

I have another sheet 'selected' with a selected list of patient IDs.
Some of these patients have an event or events on the 'events' page,
some do not.
I'd like to create another sheet where all 'events' rows with a
matching ID to the 'selected' list are displayed.
(i.e. aselected sheet of rows from 'patients' using the ID from
'selected' as the criteria

any suggestions? thought about lookups but the mutiple rows stumped
me!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create a 1
create table of selected rows 1
match duplicate data in rows and columns in Excel 2003 2
Figuring out a lengthy formula. Probably quite simple... 3
Macro ?-moving info from 1 sheet to first blank section on another 6
Comparing multiple rows of data 7
Reference every 4th row from a master list of modifiable length 1
simple but repetitive use of combobox 0

Top