I am wondering how to link worksheets so that if i have a value on worksheet
1 that it will transfer to the other worksheets along with the entire row of
data. For example if I have a 1 in 1a on worksheet one all of the data in row
one will transfer to worksheet two. OR if i have 2 in 1a on worksheet one all
of the data in row 1 will transfer to worksheet three.