Update cell value based on name and specific date

L

Leo111

Hi!
I have 13 sheets.
on the first I have names and dates of vacations like:

Names From To
Name_1 2/3/2015 10/3/2015
Name_2 14/3/2015 24/3/2015

............
Sheets from second up to 13 looks like (from january to december)

A B C D
Names 1 2 3 ---------------------------------------------- 31
Name_1
Name_2
........
My users fill only first sheet with names ( may be few times) and dates of vacations.
I need formula on the sheets 2-13 in cells from B2 up to end of the month that change value in the cells to the "V"
exactly between dates and name_X filled on the first sheet
Thanks for help
 
D

dguillett

Hi!
I have 13 sheets.
on the first I have names and dates of vacations like:

Names From To
Name_1 2/3/2015 10/3/2015
Name_2 14/3/2015 24/3/2015

...........
Sheets from second up to 13 looks like (from january to december)

A B C D
Names 1 2 3 ---------------------------------------------- 31
Name_1
Name_2
.......
My users fill only first sheet with names ( may be few times) and dates of vacations.
I need formula on the sheets 2-13 in cells from B2 up to end of the month that change value in the cells to the "V"
exactly between dates and name_X filled on the first sheet
Thanks for help

NOT clear what you want. Send file to dguillett @gmail.com with a clear explanation and examples
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top