I am terrible with excel and have been banging my head against a wall. I do some community volunteering and am trying to come up with a way to manage staff. Each month I get a spreadsheet which I want to load in as a sheet and have another sheet to use as a dashboard. It will need a search function that will search the spreadsheet and a way of checking when things are due (performance reviews, birthdays etc)
If anyone can help with any of the bits that would be great because its stressing me out and I've got no where. Pivot tables look like a great way of doing some of it but I cant get them to do what I want.
How do I attach a spreadsheet attachment?
If anyone can help with any of the bits that would be great because its stressing me out and I've got no where. Pivot tables look like a great way of doing some of it but I cant get them to do what I want.
How do I attach a spreadsheet attachment?
