Sort out data on seperate sheet
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.
|