How to sort serial number - based on another sheet serial number order

Hi all,

I have tricky and simplest question / suggestion to ask,

open to Formula or Vba approach

I have sheet 1 Data , it was arranged..... like below

The serial number got twisted.

S.no Amt
5 124.00
1 225.00
2 123.00
4 124.00
3 273.00


Based on the Sheet 1, I want to arrange the serial number of Sheet 2
in the same order of serial number

Both Sheet got equal no. of data

S.no Amt
1 225.00
2 263.00
3 3837.00
4 377.00
5 84.00


Objective is to Sort the Serial number of Sheet2, in the same order of Serial number in Sheet 1.

Any ideas !

Please Login or Register  to view this content.