Hi,
Thanks for looking. I am wanting to track some employee recruitment costs month on month, as the company policy is that the recruitment costs are spread over three months.
I have no doubt that someone will want to know the costs and the split by cost center so that is why I am wanting to track it. The information in the Detail tab is the journal that I load into the finance system, so if I can use this as a basis for the information that would be good as I can just drop the information in here once a month and update the summary.
What I am looking for is a formula in the summary tab that will lookup the persons name, against the period and a particular nominal code (picking up all nominal codes will return values of zero). I only have Octobers information at the minute.
I will the build this file over the next year.
Thanks in advance.
Bookmarks