Retrieving Data

  • Thread starter Thread starter dcronje
  • Start date Start date
D

dcronje

I have a table on one worksheet with all my data on it.

eg.

'Sheet 1'

Date Details Fault RestoreTime


I need to autmatically extract the data (records) matching a certai
criteria on 'Sheet 2'.

So basically filter the data on sheet1 by criteria set on sheet2 an
get it copied to sheet2 automatically.

Is this possible?

Thanks

Davi
 
Looks like Data/Filter/Advanced Filter will do just what you want.

You put a criteria range into a range of cells consisting of fieldname
with criteria below. Please see Exel Help under "Advanced Filter"
...etc
 
Advanced filter does not let you copy to a different sheet.

I was thinking of using the Advanced filter to copy to another place i
the same sheet and creating a dynarange which I could copy onto a ne
sheet which would then be the data for the payment mechanism. I hav
tried to do this but keep getting stuck because some of my named range
do not appear in the goto list but when you go back to defining name
they are there.

I am not sure that I am explaining it very well but hopefully you wil
get the jist of it.

Thank
 
Back
Top