Hi everyone!

Just wondering any way of creating a form that would update the table attached for monthly, quarterly and yearly figures.

Lets say if I had a form and selected finance from a drop down menu and put in weekly cost per labour into it that it would update automatically in the right month that we are in on a separate spreadsheet KPI sheet.xlsx.

It might be a long shot but I said I would give it a go and ask!!

Any help very much appreciated !!

Thanks