I'm new to the forum here, so if this is asked somewhere else, let me know. Thanks for any help!
I am trying to figure out how to keep data on the same lines connected when a sort is done.
This is complicated because the first half of sheet is CC'd from another sheet and second half of sheet is hard numbers and mathmatical formulas.
For example here is sample of data on Sheet 2
A1 = =Sheet1$A1, B1 = =Sheet1$B1, ..... AA1 = 1, BB1 = 2, CC = =(BB1-AA1)
I want to be able to sort Sheet 1 and have the hard data on Sheet 2 (AA1, BB1, CC1 etc) to stick with the copied data on sheet 2 (A1, B1, C1 etc)
I know I could a Vlookup, but that would get very large. Any other ideas?