I have a filtered list in Excel. I have created a column in another sheet with data. Now I want to import that data back into the filtered list. Being that it is filtered the rows are not in order. How do I get the data to paste into the filtered list so that it lines back up again.




Filtered List Data in other worksheet
1 <------------------ Test = Cell 1
5 <------------------ Test1 = Cell 2
8 <------------------- Test2 = Cell 3