Excel... what am I missing?

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?

Excel... what am I missing?

I would right click, copy and paste special "values" for the linked info only.

Re: Excel... what am I missing?

But I need the link.
I need to be able to edit in just one place

Re: Excel... what am I missing?

Are there any $ signs in the formulas on the second sheet? If so you need to take those out so it will stay linked to the cell even when it is sorted differently.

Re: Excel... what am I missing?

I would filter all the data on a third sheet since the second sheet has a mix of links and hard codes.

Check your inputs and formulas with CTRL~.

I always put hard codes in blue so that I know which cells I am entering input variables. It is a huge pet peeve of mine when people send me financial models that are not color coordinated properly because I have no idea what inputs are driven by formulas.

Excel... what am I missing?

Add a column in sheet 1 with a identification number and then do a vlookup on sheet 2 based on I'd number. It will always look up the number you are referencing.

Excel... what am I missing?

Thanks for the input.
I'll try them out and test them tomorrow morning

Excel... what am I missing?

Does the data that you input manually have a title in the first row too? Make sure that all the columns are filtered,not just the ones with the links. Hope this helps.