Hi,

I know my way around Excel a bit but am stumped with this and dont really know where to start. On the attached picture I have shown data in column A, B, and C. The data in column A is fixed and I want to sort the data in column B and C so it matches column A eg:

After pasteing the data in Column B and C, 1001 in B goes from cell B4 along with the value in C4 into position B2 and C2 respectively

I want this to carry on down the sheet for around 200 items. If there is a gap (say 1020, 1021 then 1024) then the formula needs to skip those rows to keep the number in column A and B the same.

Is this actually possible??

Thanks for any help.Excel.jpg