Ok, let me explain. I'm on a military base here and I am making (trying to
atleast) a WORKBOOK that can keep track of who is on LEAVE and who is NOT ON
LEAVE. It is a very simple spread sheet to keep track of who should be here
or on vacation... as follows:

WORKSHEET 1: Is called "MASTER" and it would contain the list of everyone on
base as such...
Column A: (Last, First, Middle RANK) Their name and title
Columns B thru AF: (31 columns) indicating the amount of days in a month
(excluding February-28, April-30, etc...)
Basically, in those 31 columns (corresponding to the rows next to each
persons names) I would put an "X" for everyday that they would be on LEAVE
(vacation) and an empty slot would indicate that they should be on base
somewhere,... working (supposedly).

WORKSHEETS 2-13: (JAN thru DEC) would have the SAME info as the MASTER
worksheet except it would all be "future" data of when that person/people may
be on vacation or on duty that day. Make sense so far???

Theoretically if this all worked I could look at a month (worksheet) and
date (column) for the corresponding name (row) and know if that person is on
base or on Leave (vacation). TADA! =)



PROBLEM 1:
I created the MASTER worksheet to link to the other 12 worksheets (Janurary
thru December) so that when a new person arrives on base, I can enter their
name in the Master worksheet and "Sort A-Z" it would (should) "automatically"
update all the "Column A's" and corresponding rows for each name in all the
other worksheets (Janurary thru December). Unfortunately after I use the
"Sort A-Z" function it doesn't move the corresponding rows associated to that
name with the sort function.

Question for Problem 1:
How do I lock the MASTER Worksheet "rows" to their corresponding names so
that if I were to enter a new name and filter (Sort A-Z) wouldn't JUST sort
the names but also the corresponding rows to their names.



Problem 2:
I know how to link worksheets together... (my MASTER worksheet to all the
other 12 months worksheets) but I'm not sure if I'm doing it right. I'm
copying from my MASTER and using the "Paste Special - Paste Link" onto the
other 12 worksheets for Jan-Dec.

Question for Problem 2:
Is there a better method? When I use the Paste Link method it shows a bunch
of "0's" in the empty boxes which is producing a lot of clutter and
confusion. Is there a way to link the worksheets together to the Master
worksheet without having all those "0's"? <this workbook/worksheet must be
soldier/sailor proof...if you know what i mean


I hope someone out there knows what I am talking about...and knows the
answers to my frustrating situation...


Truely Greatful,

"Frustrated"

PS. None of the discussion links had the answers I was looking for.





--
"I should have paid attention in computer class..."