Hi Mel Not sure if this is what you are looking for. It would help if you can post a sample file with the expected result. Sunny
Hi Give this a try. No need to cut and paste. Just copy the data to the required range, print and then delete the range. Sub PrintData() Dim iCo...
Hi Jessica When doing 3D summing, make sure that the new sheet(s) are added between the first sheet ">>" and last sheet "<<" else it wo...
Hi David You did not mention which column is the date to filter. I am assuming it to be column W so change it to suit your needs. Sub FilterByDa...
The only problem is a worksheet name cannot have a colon. Probably it is a semi colon
Hi David See if this is what you wanted. Please note that the range, conditions, colors etc. have to be hard-coded. You will need to modify the ...
Hi David Any reason why you would want to "store" the CF applied using VBA? Sunny
Hi Morgan You are welcome . Sunny
Hi David Thanks for your nice comments. I have updated my earlier codes to include a progress bar that was created by Philip Treacy. Hope you li...
Hi Daniel The formula is quite long but you can give it a try. I have modified your formula in column H as I need to get the fraction portion of...
Hi Paul Glad to know you have managed to resolve the problem. Cheers Sunny
Hi Paul I suggest if possible to attach a small portion of your file. I don't think it crashed as it didn't detect the change at all. Since you ...
1) Press ALT+F11. 2) Click View - Immediate Window. It should appear at the bottom right of your screen. 3) Just type Application.EnableEvents=T...
Hi Mey See attachment. Sunny
Hi Mey That is a lot of questions. Please attach a sample file with the data and the expected results.