create table of selected rows

  • Thread starter Thread starter TBA
  • Start date Start date
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
 
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
single report on data in 20 tables 1
Selecting rows to another sheet 2
COUNT rows on external sheet if between date range 3
creating a report from a table, pivot table not suitable 1
Excel print area which only prints pages of worksheet which are active 0
All sheets in workbook have same rows to repeat at top 1

Back
Top