Hi Stephanie The VLOOKUP is unable to locate the codes 1010 to 1050 from your Pdt Codes sheet. This is because these codes in the Data sheets ar...
Hi Paul Give this a try. It uses ARRAY formulas so you must press CTRL+SHIFT+ENTER instead of ENTER when you edit the formula. Hope this help...
Hi Kris In cell E2 enter =WORKDAY(D3,IF(C3="PSR",15,20),$B$22:$B$29) Hope this helps. Sunny
Hi Kim Glad to know all is working fine. To answer your question: 1) Select the range you want to unprotect (cells I3 to T3 in your case) on ...
Hi Saliha Right-click on the Print button and select Assign Macro. Select PrintForm and click OK. Sunny
Please check your macro setting.
Hi Vasim From my understanding, you wanted to update the cycle time and remark using the user form. You also wanted to save the old values to th...
Hi Kim Thanks for your feedback. Hope you will be able to dazzle your boss Cheers Sunny
Hi Melinda Thanks for your feedback. Cheers Sunny
Hi Stephanie Thanks for your feedback. Glad to know it is working for you. The only explanation i can think of is the code you used is not corre...
Hi Melinda Give this a try. I have added a helper row to identify the week number (hope it is correct) Select the required month and then cli...
Hi Kim I am using a helper column (column W) in the ACTUAL and BUDGET sheet to extract the figures needed. I then refer to them from the ACTUAL ...
Hi Stephanie Try replacing With Sheets("Repeated Accs (2)") .Range(y).Parent.Select End With with Union(b, c).Select Hope thi...
Hi Stephanie Can you attach your file with some sample data so that we can see what you are trying to check. It will give a clearer picture. ...
Hi Kim My previous reply included an attachment with the formulas to get the result. You will just need to modify them to suit your needs. Su...