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
Bookmarks