Hi Philippe Could you elaborate more on how you would like to conditionally hide/show your graph?
Hi Jason You can first Paste As Values and then Paste Formatting. Hope this helps.
Hi rathanak Your code will cause an error if user press ESC/Cancel or enter a non-existence sheet number. I have modified your code so give it a...
Hi Patrick Normally I would looking at what is selected in the 1st row of the PivotTable and then do a lookup using VLOOKUP/INDEX/MATCH/OFFSET etc....
Another try =IFERROR(INDEX({0,1,5},(MATCH(HOUR(B1),{7,6,16},0)+MATCH(HOUR(B2),{17,16,22},0))/2),0) Cheers
See if this is what you want =IF(AND(HOUR(B1)=6,HOUR(B2)=16),1,IF(AND(HOUR(B1)=7,HOUR(B2)=17),0,IF(AND(HOUR(B1)=16,HOUR(B2)=22),5,0)))
Hi David This is due to the fact that cell J2 will retain the previous validation result and is not cleared. You can refer here for more details...
Hi David Glad to know it helps. Cheers Sunny
Most projects do not require complicated Userforms and the data entry screen can be created on a worksheet. Do the validations on the worksheet itself...
Hi David Are you looking for something like this? Please refer attachment.
Refer sample attached
My suggestion. (1) Analysis of claims for the year Use a Pivot Table. It is the fastest and easiest way to analyze data (2) Make sure total c...
Glad it helps. Sunny
Hi Tony Glad it helps. No codes are 100% perfect the first time. Definitely need some fine tuning. Good luck. Cheers Sunny
Hi rathanak See if this is what you want.