Thread: Paste link issue

I have two identical sheets in a workbook which are not sorted. I want to link an input column from one sheet to the other using the paste command. However if I sort the sheet for ease of data entry, when i sort the links between the sheets do not realign. For example the link Sheet 1 cell 2 to Sheet 2 cell 2 remains the same after sorting sheet 1. I have over 600 records and i want the cells to be able to cross reference the sorted versus the unsorted version. After sorting the file may different sequence. E.g. sheet 1 is sequenced 1,2,3,4,5 but the sorted version based on another column may be 3,5,2,1,4. When I enter data in 3 sorted, i want it to also refernce 3 (not1) in the insorted

Without seeing how your data is laid out, I'd suggesting taking a look at the ROW and VLOOKUP functions. You could insert a "helper" column, and using the row function could always know what row your data was on. You could then use VLOOKUP to return this data based on its row.