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.

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.

Thanks Otto for replying. This is all one workbook and all my sheets in the
workbook have the same column heading. I guess what I'm trying to do is sort
out mini lists from the master list while keeping the master list in tact. I
want to automate this with a macro becasue my volunteer list changes weekly.

I only have a few columns in all my sheets, they are
"Name" "WPhone" "HPhone" "Available" "Task"
A B C D E

I want to only copy and paste to my "Plumbing Weekend" Sheet those
volunteers who have "Plumbing" in their Task column and "Sat" and "Sun" in
their "Available" column. Does that help at all. I want to keep this all in
the same workbook.

Thank you very much.

"Otto Moehrbach" wrote:

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.

Linda
This little macro will do what you want. This macro assumes the
following:
The destination sheet is named "Plumbing Weekend".
The name of the source sheet doesn't matter, but it must be the active
sheet.
On both sheets, the headers are in row 1 and the data starts with Column A.
As written this macro copies only the Plumbing and pastes it into the
destination sheet. Do you need this macro to do the same thing for all the
other destination sheets? I would think so but you asked for only the
plumbing. If so, give me the sheet names as well as the corresponding
"Task" listing in the source sheet. HTH Otto
Sub CopyPlumbSatSun()
Dim RngColA As Range
Dim i As Range
Set RngColA = Range("A2", Range("A" & Rows.Count).End(xlUp))
With Sheets("Plumbing Weekend")
For Each i In RngColA
If (i.Offset(, 3) = "Sat" Or i.Offset(, 3) = "Sun") And _
i.Offset(, 4) = "Plumbing" Then _
i.Resize(, 5).Copy .Range("A" &
Rows.Count).End(xlUp).Offset(1)
Next i
End With
End Sub

"Linda" wrote in message
...
Thanks Otto for replying. This is all one workbook and all my sheets in
the
workbook have the same column heading. I guess what I'm trying to do is
sort
out mini lists from the master list while keeping the master list in tact.
I
want to automate this with a macro becasue my volunteer list changes
weekly.

I only have a few columns in all my sheets, they are
"Name" "WPhone" "HPhone" "Available" "Task"
A B C D E

I want to only copy and paste to my "Plumbing Weekend" Sheet those
volunteers who have "Plumbing" in their Task column and "Sat" and "Sun" in
their "Available" column. Does that help at all. I want to keep this all
in
the same workbook.

Thank you very much.

"Otto Moehrbach" wrote:

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.

HI Again Otto,

Thanks so very much for your help.

Because my volunteers call in daily with their schedules, I need to be able
to just update my master list and run the macro to update my tabs(sheets)
with their availability for the week.

My tabs(sheet names) are "Siding", "Roofing", "Plumbing", "Framers",
"Electrical", "Interior Finish". I want to just pull into those lists my
time slots "Available: which are "Sat" and/or "Sun". I'm sure if you can
help me with a tab or two, I'll try to finish the rest.

I'm thinking I just need to open the master list, run a macro that updates
all my sheets, is that correct?

Yes, my headers are on row 1 and data starts in column A.

You are a life saver...this will may my life so much easier as folks
availability changes daily.

Thanks so much.

Linda

"Otto Moehrbach" wrote:

Linda
This little macro will do what you want. This macro assumes the
following:
The destination sheet is named "Plumbing Weekend".
The name of the source sheet doesn't matter, but it must be the active
sheet.
On both sheets, the headers are in row 1 and the data starts with Column A.
As written this macro copies only the Plumbing and pastes it into the
destination sheet. Do you need this macro to do the same thing for all the
other destination sheets? I would think so but you asked for only the
plumbing. If so, give me the sheet names as well as the corresponding
"Task" listing in the source sheet. HTH Otto
Sub CopyPlumbSatSun()
Dim RngColA As Range
Dim i As Range
Set RngColA = Range("A2", Range("A" & Rows.Count).End(xlUp))
With Sheets("Plumbing Weekend")
For Each i In RngColA
If (i.Offset(, 3) = "Sat" Or i.Offset(, 3) = "Sun") And _
i.Offset(, 4) = "Plumbing" Then _
i.Resize(, 5).Copy .Range("A" &
Rows.Count).End(xlUp).Offset(1)
Next i
End With
End Sub

"Linda" wrote in message
...
Thanks Otto for replying. This is all one workbook and all my sheets in
the
workbook have the same column heading. I guess what I'm trying to do is
sort
out mini lists from the master list while keeping the master list in tact.
I
want to automate this with a macro becasue my volunteer list changes
weekly.

I only have a few columns in all my sheets, they are
"Name" "WPhone" "HPhone" "Available" "Task"
A B C D E

I want to only copy and paste to my "Plumbing Weekend" Sheet those
volunteers who have "Plumbing" in their Task column and "Sat" and "Sun" in
their "Available" column. Does that help at all. I want to keep this all
in
the same workbook.

Thank you very much.

"Otto Moehrbach" wrote:

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.

Linda
It's much easier for me and you if I write the macro to do all the
sheets.
One thing I need to tell you and you tell me if this fits in with what
you are doing. It is much more difficult (much more code needed) for me to
write the macro to only update the sheets with the latest information. It
is much easier if I write the macro to clear (erase) each sheet, in turn,
and then copy ALL the info pertaining to that sheet. This would be a
problem for you if you are manually putting other information into each or
some of the sheets because the code might erase that. Let me know on this.
I'll assume, until I hear different from you, that it's OK to clear each
sheet.
I understand that the sheet names and the task wording are the same. Is
that correct?
Do you want the sheets sorted (simple code required)? By name only? Or by
name and then by task?
How about sorting the Volunteer sheet at the same time? Would that help
you? Sort by what?
Otto
"Linda" wrote in message
...
HI Again Otto,

Thanks so very much for your help.

Because my volunteers call in daily with their schedules, I need to be
able
to just update my master list and run the macro to update my tabs(sheets)
with their availability for the week.

My tabs(sheet names) are "Siding", "Roofing", "Plumbing", "Framers",
"Electrical", "Interior Finish". I want to just pull into those lists my
time slots "Available: which are "Sat" and/or "Sun". I'm sure if you can
help me with a tab or two, I'll try to finish the rest.

I'm thinking I just need to open the master list, run a macro that updates
all my sheets, is that correct?

Yes, my headers are on row 1 and data starts in column A.

You are a life saver...this will may my life so much easier as folks
availability changes daily.

Thanks so much.

Linda

"Otto Moehrbach" wrote:

Linda
This little macro will do what you want. This macro assumes the
following:
The destination sheet is named "Plumbing Weekend".
The name of the source sheet doesn't matter, but it must be the active
sheet.
On both sheets, the headers are in row 1 and the data starts with Column
A.
As written this macro copies only the Plumbing and pastes it into the
destination sheet. Do you need this macro to do the same thing for all
the
other destination sheets? I would think so but you asked for only the
plumbing. If so, give me the sheet names as well as the corresponding
"Task" listing in the source sheet. HTH Otto
Sub CopyPlumbSatSun()
Dim RngColA As Range
Dim i As Range
Set RngColA = Range("A2", Range("A" & Rows.Count).End(xlUp))
With Sheets("Plumbing Weekend")
For Each i In RngColA
If (i.Offset(, 3) = "Sat" Or i.Offset(, 3) = "Sun") And _
i.Offset(, 4) = "Plumbing" Then _
i.Resize(, 5).Copy .Range("A" &
Rows.Count).End(xlUp).Offset(1)
Next i
End With
End Sub

"Linda" wrote in message
...
Thanks Otto for replying. This is all one workbook and all my sheets
in
the
workbook have the same column heading. I guess what I'm trying to do
is
sort
out mini lists from the master list while keeping the master list in
tact.
I
want to automate this with a macro becasue my volunteer list changes
weekly.

I only have a few columns in all my sheets, they are
"Name" "WPhone" "HPhone" "Available" "Task"
A B C D E

I want to only copy and paste to my "Plumbing Weekend" Sheet those
volunteers who have "Plumbing" in their Task column and "Sat" and "Sun"
in
their "Available" column. Does that help at all. I want to keep this
all
in
the same workbook.

Thank you very much.

"Otto Moehrbach" wrote:

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.