| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update cell value based on name and specific date
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Update cell value based on name and specific date
On Thursday, January 8, 2015 at 5:36:14 AM UTC-6, Leo111 wrote:
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically update a cell with a date based on anther cells date | Excel Discussion (Misc queries) | |||
| input a date or update it based on date in another cell | New Users to Excel | |||
| Update a cell with a specific value related to a date. | Excel Worksheet Functions | |||
| How to update a cell if a specific date is included in a date rang | Setting up and Configuration of Excel | |||
| Update cell based on date range | Excel Discussion (Misc queries) | |||
Linear Mode
