Posts by tuffley21


Got it Thank youuuuuuuuuuuuuuuuuuuuuuuu

Still get the result from column B not from column E

Thanks NBVC I will give it a go!!!!!!!!!!

Thanks
Could you please show how to modify this!!!! 
Could not figure out how to modify the formula to read newly added data from E473 to T40 in this inherited work book
Sheet = CTF Data
Thanks 
Re: Conditioal Counting VBA worksheet Change Event
Hi Carim
Please advice on how to fix the when "mycount() function stop working. Stop updating @ the movement :smash:
(MoveAfterReturn and EnableAutoComplete are ticked) 
Re: Conditioal Counting VBA worksheet Change Event
Thanks I will:fatwalk:

Re: Conditioal Counting VBA worksheet Change Event
:smile: Thanks again Carim
I have to go back to drawing board/////What I mean in calculation is > when "Pass" starts in a column , sum to be on that column (eg, 3 passes x then
24 on the start column , Not like 24 16 8 in respective Columns////Thanks again, appriciated

Re: Conditioal Counting VBA worksheet Change Event
Hi Carim
1When selecting the "Pass" the result should be in that column only(Row 3 for F type or row 4 for C type)
2Formula at the movement does not pick the current rate from code sheet, (now it picks the first value always regardless to current value) 
Re: Conditioal Counting VBA worksheet Change Event
Hi Carim
Extend the functionality of to UDF
Lookup and calculate depend on the Type and the latest date value 
Re: Conditioal Counting VBA worksheet Change Event
Carim
Excellent Thank you Again :rock::rock:
( I will be back if I hit a dead end!!!) 
Re: Conditioal Counting VBA worksheet Change Event
Carim /Pike
What is the best way to run Multiple macros depend on cell value
Worksheet_Change event with case statement causing grief............ 
Re: Conditioal Counting VBA worksheet Change Event
Thanks you Carim  good :congrats:
Thank you Pike too :thumbcoo: 
Re: Conditioal Counting VBA worksheet Change Event
Thanks Pike, appreciated
Dates on columns are growing as well as people in column F
If you could do it VBA much appreciated
This formula calculates if any entries beyond today's date 
Hi guys
Need to count & display the results in column D
for all the people in Column F
from the date > than on Column E to Todays date
and not equal to "Absent"
Thanks in advance
(File attached) 
Re: Delete columns if range is empty
thanks
got it
'///ColName = "OV"
Debug.Print Range(ColName & 1).Column '// 
Re: Delete columns if range is empty
'/// If WorksheetFunction.CountA(Cells(1, lngCol).EntireColumn) <= 2 Then'//  this prompt me for column to be deleted, good and thank you and what is easy way to find column number for "OV" pl


Re: Delete columns if range is empty
I tried changed if statement from 1 to 3 and Ingcol but no luck