Forum

I could not open your table, but here is a response from ChatGPT: Sub TransferData() Dim LastRow As Long ' Find the last row wit...

Solution from ChatGPT: Sub ExtractMisspelledWords() Dim rng As Range Dim cell As Range Dim misspelledWords As Object ...

I was trolling through the forum and came across this question. I thought Mynda’s solution was clever. So did ChatGPT, “This is the clever part “ is...

I assume the problem has been resolved since there is no activity for a while. However, I'll add my two cents. I had a similar issue when I import...

Hi, I noticed that quite a few views but no replies. I'll take a shot at it, but I don't understand what you are trying to do. Looking at the att...

Was you problem solved? If not what went wrong?

I tried to add the file here.

This is the third time I have tried to submit a reply here. You can submit the whole file with the name tbl_Refreshed as long as it has the same numb...

Hi, Thank you for taking the time to answer my questions. I should have picked up on the "Pos." I am working on your formula and found an expla...

Hi, I looked at Catalin's solution, and I'm impressed. Both the formula and Power Query work for any part number and any month. I noted the formu...

Hi, I was just looking for a Power Query solution that accomplished what your formula accomplished. But since you asked, could you switch which mo...

Hi, Would it be possible to store your data and updates on a thumb drive, then set the "Source" in PQ to the thumb drive. I was never a fan of d...

Hi Mynda and Catalin, Thank you both for taking time to reply. Both are perfect answers and both of you are the greatest. I knew there had to b...