Hello experts,
I tried to find help elsewhere but I didn't get any answer.
I have one Worksheet, which is formated as month calendar with none working days (Saturday and Sunday) and another holidays (the holidays are set it in a range in sheet Variabile, and can be updated) and I have 2 user defined formulas that i need to uprade them.(VBA Module)
Each cell in range are a list from data validation, and each cell have a numeric value set it allready in UDF, but the cell value need to be updated by next cell value, which is variable, and for all my UDF need to be upgrated with next scenarios:
- For UDF 1 Ore_Lucrate (colum AJ):
1. if curent cell is SP, SL, T, Bdoc and next cell is Rec, Rsl, CO, CM the cell value to be 25
2. if curent cell is SP, SL, T, Bdoc and next cell is SP, SL, T, Bdoc or is numeric the cell value to be 24
- For UDF 2 ore_Ms (colum AL):
1. if curent cell is "SP", "SL", "T", "Cont", "Int", "Bdoc" is the day before a holidays, the cell value to be 9.
2. When cell Value is a number and it is Sunday value is not sum it, so I want sum it.
Excel version is 2007.
Thank you in advance and I hope i was explicit.
Bookmarks