NidwaldenBeck
New Member
- Joined
- May 10, 2017
- Messages
- 2
Hi. I'm hoping someone can help, I'm not sure of the best approach to take.
I have a large table with a column for each person and a row for each day of the year. Each cell in the table contains the cost of that person for that day.
I would like to set up a separate worksheet that will be the monthly invoice. On the invoice sheet I am using a list validation cell. Once the name is selected in that cell I want the price for each day of the month for that person to automatically populate.
I can't figure out how to fill the cell based on the name and date.
Please can you help?
I have a large table with a column for each person and a row for each day of the year. Each cell in the table contains the cost of that person for that day.
I would like to set up a separate worksheet that will be the monthly invoice. On the invoice sheet I am using a list validation cell. Once the name is selected in that cell I want the price for each day of the month for that person to automatically populate.
I can't figure out how to fill the cell based on the name and date.
Please can you help?