View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LINDA LINDA is offline
external usenet poster
 
Posts: 205
Default 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.