Hi Fatyn From your example, you only need 2 values from the combo box i.e. Name and Job Allocation. The formula for the summary calculation can ...
Hi Louise e.g. in cell AN12 you can write =COUNTIF(C12:AM12,"H")+(COUNTIF(C12:AM12,"HD")/2) Hope this helps. Sunny
Hi Hava In your example, cell A1 cannot be blank. Just enter something into A1 and then use the method that I have suggested above. Hope this he...
Hi Andy Give this a try
Hi Melinda Perhaps something like this? What I am doing is : 1) Join the range 2 times using CONCATENATE(). This will allow me to "loop" back...
Hi Troy You can try ActiveCell.Formula = "=Date(Year(Today()),1,1)" or Range("B15").Formula = "=Date(Year(Today()),1,1)" You don't ne...
Thanks for your feedback. Happy to know it works. Sunny
Hi Curt Try this but I suggest you use sample files as your codes above saves and override your original files (very dangerous) 1) Add this to t...
The macro works on the active sheet. Lets say the macro is saved in Workbook A. You open Workbook A then open Workbook B. Select the sheet to...
Hi Curt In which column is the string "HOURS AND RATES" located? The below code assumes that it is in column A. Change if it is in another colum...
Hi Julie This question had already been answered before:
Hi Andy No problem. Merry Christmas Sunny
Glad to know you got it sorted out Sunny
Hi Dan Did you try what I suggested? I makes no difference whether the data comes from another workbook. It will give you exactly the same re...
Hi Andy Try this. If it is not working then give me some sample dates and which starting period you expect the staff's name to appear. Sunny