Hi guys,
Is there a way I can use name manager for my spreadhseet, where I use an ID (column A) or name (column B) to create columns as part of name maanger for each month.
I.e Column C, is May 2020. I have 3 columns with the holiday pay, total (for work pay), then a column for holiday + total.
I want to have name manager to show: Holiday pay for john in may, total (for work pay) in may for john, holiday + total in may for John.
Then I can create this for the other employees and repeat this process for other months.
I need this to easily calculate accruals over more than 1 month. Rather than doing cell references.
Any help appreciated pls!
Bookmarks