Forum

Hi Azatat, Without your workbook and data it's a bit hard to know that I'm working on this correctly, but I think all you need is an IF AND formula...

Hi HR, There's no attachment in your last post. Regards Phil

Hi Lajos, Yes this can be done. However, if I write code now based on the sample data you entered above which I have to copy into a new workbook, t...

Hi, I don't know the exact format of your text files but you could merge them all from Terminal then just import 1 file? Place all the text file...

Hi AM, Not sure why you are getting #REF without seeing what is causing that error. If you have XLOOKUP you can use 2 nested XLOOKUP's - see att...

Hi Lea, Do you want to send them a copy of the sheet? Or send them a PDF? Or an image? Will each person get the same report? I'm not sure w...

Hi Steve, If you are reading the filename from a cell, why do you need to display a dialog box asking for the filename? I'd just check if the ce...

Hi Gabriel, Similar problem. You have 2 bits of code setting the reg date. In this sub your setting it to CValue after you'd set it to the dat...

Hi Branden, This seems overly complicated to me, but maybe I'm not understanding exactly what you are trying to do. If services happen every 500...

Hi Steve, In the ThisWorkbook module use this event: Private Sub Workbook_BeforeClose(Cancel As Boolean) Cancel = True ' YOUR CODE GOES HERE ...

Hi Gabriel, You had two pieces of code setting the value of Birthday. The 2nd one set the value to a variable called cValue but this had no value ...

Hi Mariam, Have you read this post Regards Phil

Yes, just change Range("A1") to Range("A2")

Hi Mel, You could do this with VLOOKUP or XLOOKUP and avoid having to create a form and write VBA to make the form work. Create a new sheet and c...

Hi Louise, It looks like you are working with numbers stored as text. The RIGHT function is for strings. So is everything a string or do you have...