Excel... what am I missing?
Posted 2/7/2017 3:51:41 PM by MarathonKnitter

I created an excel file.
In sheet 1, I put in the majority of my data.
In sheet 2, I linked some of sheet 1 PLUS additional info. This additional info was put in manually and is not linked to any other data.

When I filter data on sheet 1, it affects sheet 2.... BUT ONLY the linked info. This means that when I go back to sheet 2, the info I manually typed is no longer on the same row as its corresponding data.

What did I do wrong?
How can I make sure all the columns stay together on sheet 2?
Print Post      Close Window