Hi Matt, sorry, ive got alot on at the mo.

In the workbook you posted I cannot see how you got the data from sheet "TOPLINEREPORT3PLUK"

into sheet "TOPLINE QUERIES" as they are values only. As such I cannot comment why you are getting the 22 rows of blank data.

In Sheet "TOPLINE QUERIES"

Cell A2

=INDEX(TOPLINEREPORT3PLUK!G6:G6,COUNTA(TOPLINEREPORT3PLUK!G6:G6))

Drag accross and down as far as you want.

With this you can type into sheet "TOPLINEREPORT3PLUK" Cols G, H and I and Sheet "TOPLINE QUERIES" will reflect what is typed - although re sorting in acsending order i think you will have to do that manually unless s'one offeres a VBA solution.

Hope this helps.