I am trying to link variable data from one worksheet (my source worksheet) to
several other worksheets. For example, my source worksheet has two variables
or columns: 'Team' and 'Bye Week'. The first entry under the 'team' column
reads 'NE'. Let's say for this example that the first entry under the 'Bye
Week' column is the number '10'. Given this, I want every entry under the
'Team' column in other worksheets that read 'NE', to read the number '10'
under the 'Bye Week' column. Let's also say that one of the entries under
the 'Team' column reads 'BAL'. For every entry in the 'Team' column that
reads 'BAL' in other worksheets, I want the entry in the 'Bye Week' column to
read the number '5'. So on and so forth. To summarize, I need to link each
piece of data in column "A" ('Team') to it's corresponding piece of data in
column "B" ('Bye Week') across other worksheets. I hope my explanation is
not too confusing. It might sound like a trivial problem, but I haven't
worked with Excel in this manner before and this would make my life so much
easier for years to come. Thank you in advance for your input and help. I
am using Microsoft Office 2003.
--Ty