create table of selected rows

T

TBA

Hi there. I have a sheet 'patients' with 'A' Row being an ID taking the form
S002, S003 etc. I have another sheet 'selected' with a selected list of IDs
in the same form. I'd like to cretae another sheet where only the 'selected'
list appears (i.e. aseletced sheet of rows from 'patients' using the ID from
'selected' as the criteria

many thanks for any tips. cheeers Theo
 
T

TBA

forgot to note that the 'patient' sheet has multiple rows with the same ID. I
wpould want all rows with the ID to be on the new sheet
 

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

cretae a sheet of selected rows 2
create a 1
Need help referencing b/w sheets for school project 0
Copy and shift data automaticaly 0
Excel does not accept text format! 0
Create a list of unique entries based on several columns 1
sumif issues 1
Sheet selected, automatic return to top of sheet 7

Top