Hello, So I made a template sheet that I saved to %appdata%\Microsoft\Templates, so I select it when I right click the active sheet name -> insert > select my template. However, I am looking to do one of those 2 things : When I click the + to create a new sheet, I would like it to automatically add my template and today's date as the name of the sheet. or If I insert my template, automatically change the name of my new sheet with the template to today's date. How can I do that ? I know nothing with VBA. I appreciate the help ..read more

Hi All Please find attached 2 files. 1 is for test data and form, the other is a screen shot of how I would like the form to resemble (formatting etc) As the data returned into the form is dynamic, I cannot resolve to set the format as per the picture. If anyone can help, that would be tremendous. Personal thx to p45cal who helped big time with the original code cheers.... Attached Images alex1.jpg (188.9 KB) Attached Files Site Questionaire_v1.2.xlsm (46.5 KB ..read more

I ask for help with the following : I would like the distance (number of rows) between the values in column I that are greater than or equal to the value entered in cell D1 to be returned in column B, I'm working on excel 2021 thanks in advance for the support Attached Files DISTANCE.xlsm (16.2 KB ..read more

What I would like to do is put in a Dept Code in B1 on my Summary doc, find said Dept Code in my Call Placement doc and then bring back the months' data and paste into the appropriate months' column(s) on the Summary doc. I've created a Worksheet_Change sub on the doc but not sure how to get started copying/pasting the data from one doc to another. The issue I can't seem to overcome is that the number of columns in the Work Placement document could change depending on the current month. For instance if it's December 2024, it'll just have 1 column. If it's January 2024, it'll have 12... and an ..read more

Hi All, I’m having difficulty working out how to sum (column) across multiple columns (criteria) and then delete those records except for one record (contains the sum). SourceFile Classification FullName Type Date AmountLocal Country AmountRegion Region ABG AlphaBetaGamma White 18/01/2024 5.00 GER 6.50 AUS ABG AlphaBetaGamma White 18/01/2024 7.00 GER 9.00 AUS ABG AlphaBetaGamma Blue 18/01/2024 5.00 GER 6.50 AUS ABC AlphaBetaCorr Green 19/01/2024 3.50 GER 5.00 AUS PseudoCode Where multiple (same date) records exists (criteria: FullName, Date, Type) sum (criteria: AmountLocal ..read more

Dear all, I am trying to write an excel vba to calculate the overtime hours of our staff during every week of a month but my coding fails to calculate the hours correctly in some scenarios. (case 3 in sample data) Target: the overtime period starts from Monday to Sunday every week and the first 4 hours claimed by our staff will be calculated by normal rate while the remaining hours will be calculated by extra rate. File: Sample Data is under sheet "Sample Data" and the expected result is under sheet "Result". Coding is as follows (multiple IF statements to check whether the 1st 4 hours h ..read more

Excel 365 beta channel has given us a look at three new functions "Regextest, Regexreplace, & Regexextract". As I understand it they are as follows: 1. Regextest. Enables the User to test the validity of a String based on the pattern. Example. You require a User to enter a correct phrase in cell D14. In another cell say E14 you could write Code: =RegexTest(D14, "Hello World", "world") Would result in "True" whereas "Whirled" would result in "False" because the pattern is incorrect. 2. Regexextract. Enables the User to extract a substring from within a string. Example. You need to extr ..read more

To my fellow VBA developers. If you have projects that depend on the Scripting Runtime library, beware. VBScript is going to be turned off and subsequently deprecated on Windows clients. Things like the Dictionary object, the FileSystemObject and other useful libraries will no longer be available and cause compile errors in your code. It isn't happening soon, but at least you'll have time to plan ahead: https://techcommunity.microsoft.com/...s/ba-p/4148301 ..read more

Welcome to VBAX Rasec. I'm concerned here that you are asking us to assist you in breaking a companies security policy, therefore I have closed the thread. If you have genuine reasons for this thread to be reopened you may PM me and we can discuss it ..read more

Just wanted to congratulate to all the people that support this great site. I really cannot say that I was able to solve those god awful problems that I had to face during my work life :-). A big thank you to ALL ..read more