Hi Otto.

I coordinate the weekend volunteers for just certain functions I can
supervise. My current tasks are limited to just "Elect", "Roof", "Plumb",
"Framers",Here are how my tabs are across the bottom of my book

Volunteers Plumb PLSAT PLSUN PLSATSUN Roof ROOFSAT ROOFSUN
ROOFSATSUN Electrical ELECSAT ELECSUN ELECSATSUN FRAME
FRAMESAT FRAMESUN FRAMESATSUN


Each Row of data includes the persons contact information, one task (so more
than one row is used if they can work more than one task) the availability
columns are Sat and anohter column for Sun and then another column for
SatSun. If they can work Sat, the test Sat appears in the Sat column only.

This is my first attempt to set up a recording system so it may not be the
most efficent, but I do think this will work for what I need. When we work
on Saturday, I can run the list of who is availabe for that day for that job.
I hope this makes sence.
Thanks so much Otto....I can't thank you enough.

"Otto Moehrbach" wrote:

Linda

Do you mean that you have sheets with the task names and then
you have sheets with the same task names followed by "Sat"? Do you have
this for every task?

Perhaps it would be easier on both of us if you send me your
file. Then I wouldn't have to ask all these questions. If you feel that
some of the data is proprietary, just fake the data. I just need the layout
and the sheet names and the task names.

We've been talking about "Sat" and "Sun" only. Do you have a
similar task with the other days of the week? Believe me, it's much easier
to do everything you need in one shot, so tell me everything you need.

Also tell me the version of Excel you are running.

My email address is . Remove the "nop"
from this address. Otto

"Linda" wrote in message
...
HI Again Otto,

Yes, it is perfecty OK to delete previous, then I will only be looking at
the most current volunteer availability. I hope the code isn't too
complicated since I may need to add more sheets down the road.

I would like to keep sheet one in tact at all times, that is my master
list
of "volunteers". I download that from a master list on tab 1 which I
download sometimes 2 times a day. Then from tab 1, I'd like my sheets
which
are titled below to include who can work "Sat" and "Sun". Then I have
another set of Job Tabs for "Sat" only. Most of the time I just use the
"Sat"
report but sometimes I need both "Sat" and "Sun" so I made both tabs for
all
jobs noted below.

I certainly hope this isn't way too complicated, I thought this would be
easy, just to update the sheets from the master with a macro. I learn
something new every day!

Thank you so very much.
"Otto Moehrbach" wrote:

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.