You can use any variable from any Excel worksheet on any other worksheet even if they're not in the same workbook. Just copy a variable on one sheet, switch to the other sheet and do a "paste link".

Then, they will stay sync'd. You can also put the reference worksheet name in front of the variable name like TC's example.

__________________
-Evan


Benz Fleet:
1968 UNIMOG 404.114
1998 E300
2008 E63


Non-Benz Fleet:
1992 Aerostar
1993 MR2
2000 F250