Linda
Not sure of what you have and also not sure of what you want to do.
You have a Master sheet that has various columns but for this purpose
you want to pull data from only the "Available" and "Task" columns. I think
I have that right. Do I? What I don't know is anything at all about where
you want this data to go. You say you have "several" sheets and you want
this pulled data to go into those sheets. Where in those sheets? In what
columns? In what rows? Do those sheets have names that relate somehow to
the data that is being pulled? Please post back with more detail. HTH
Otto
"Linda" wrote in message
...
This is more difficult than I thought. I have a workbook titeld Habitat.
I
have a large spreadsheet with my volunteer information on it. I've
created
separate sheets and I want to pull various combinations of data from the
master sheet titled Volunteers to the other sheets. The data I'm pulling
from is just based on two columns, the "Available" Column and the "Task"
column. For instance, I want to copy and paste the result for

From the Task Column = Plumbing
From the Available Column = "Sat" and "Sun"

How would I write something like this. Thank you.