|
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? |