Link or join worksheets?
 

I have 3 Excel name/address worksheets, 2 being smaller subsets (calendar and
Xmas) of the first large worksheet called "cards". Although Xmas and
calendar are included in card, I would like to import their origin back into
card by populating a new column which new column would contain "calendar" or
"Xmas" or both, letting me know that they are members of these subgroup
worksheets. When address changes are reported back to me I only need to
change one worksheet and not sometimes 3.

Thanks in advance.

--
RMG

Link or join worksheets?
 

I forgot to ask my question. How do I easily get this information from the
Xmas and Calendar worksheets loaded into this new column in the "cards"
worksheet? Thank you.

--
RMG


"RMG" wrote:

I have 3 Excel name/address worksheets, 2 being smaller subsets (calendar and
Xmas) of the first large worksheet called "cards". Although Xmas and
calendar are included in card, I would like to import their origin back into
card by populating a new column which new column would contain "calendar" or
"Xmas" or both, letting me know that they are members of these subgroup
worksheets. When address changes are reported back to me I only need to
change one worksheet and not sometimes 3.

Thanks in advance.

--
RMG