Hi Folks
Old problem, new approach.
In the attached worksheet the Rows in Cols A to F are auto updated from another program.
Each new update pushes the previous rows down one so that the latest update is always showing in row 2.
On another Sheet I want to be able to reverse the order so that the first row updated stays as the first row (row 2) and each subsequent one is displayed under the previous etc.
The info showing in row 4 was the first update brought in so I need it to display in the new sheet as row 2 etc.
I have no control on the way the program brings in and displays the updates.
Can this be done either with code or formula or both?
Cheers
Hammer
Bookmarks