Posts by tuffley21

Thanks Again -

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
1-When selecting the "Pass" the result should be in that column only(Row 3 for F type or row 4 for C type)
2-Formula 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

If Cells(3, lngCol).Value = vbNullString And WorksheetFunction.CountA(Cells(3, lngCol).EntireColumn) = 1 Then

this is the changes made to code but nothing happened when run, any suggestion please!!!!!!!

Re: Delete columns if range is empty

I tried changed if statement from 1 to 3 and Ingcol but no luck