Hello all,

so i have managed to link a database with excel and it all links up nicely, when queries update, excel updates.

HOWEVER . . .

i have formulas on the spreadsheet which times two values from the database to work out someone's wages (hours x wage = Pay)

but what i want to do is when a NEW update comes in from the database i want excel to make a new formula to give me the Pay for the newest entry.

I hope this makes sense.

Anthony