Hi i have this great script that looks up my availabilities sheet and makes a nice avails roster which shows the dates available in a month etc
i need to be able to control which days show - eg. i only want fri and sat to list and bypass the thu and sun from the availabilities sheet.
avails setup
http://www.whirlwindent.com/test/avails.pdf
output
http://www.whirlwindent.com/test/output.pdf
code on output page
=IF(ISERROR(concatmth2(INDIRECT(I$5),C10)),"",(concatmth2(INDIRECT(I$5),C10)))
script
[/code]
i need to be able to select the days i want and then the months will only show those variables?
i need to be able to control which days show - eg. i only want fri and sat to list and bypass the thu and sun from the availabilities sheet.
avails setup
http://www.whirlwindent.com/test/avails.pdf
output
http://www.whirlwindent.com/test/output.pdf
code on output page
=IF(ISERROR(concatmth2(INDIRECT(I$5),C10)),"",(concatmth2(INDIRECT(I$5),C10)))
script
Code:
Function ConcatMth2(rng As Range, item As String, Optional dte = True)
Application.Volatile
For Each ce In rng
If ce <> "" And Sheets(rng.Parent.Name).Cells(2, ce.Column) = item Then
If dte Then
holder = holder & Format(ce, "ddd d") & ","
Else
holder = holder & ce & ","
End If
End If
Next ce
ConcatMth2 = Left(holder, Len(holder) - 1)
End Function
i need to be able to select the days i want and then the months will only show those variables?