Thank you for your help

Hello Chester, Thank you for the video. How would I change the code to select if the cell contains any text and paste only values?

i used that tool and the recovered files are corrupted or unrecoverable :/

Thank you so much Sir.

Thank You.

Good stuff.

so helpful thanks man

This didnt work and i have no ckue what to do:( to restart my laptop i have to pull down a screen but i cant without a cursor

Hi i am wondering if you could give me some advice, i downloaded the template from your links but the macros dont work with Mac it seems, is there anything i could do to fix this?

Nice & concise & to the point. How do you change the Title of the Table of Contents?

If range is mixed like 1-5 and 3-5 then what we can do to find both data for single lookup value

Thanks!

Awesome! it solved the issue! thanks for sharing :)

Thanks man. Still i am not tried it. But even hope so it's will definitely work❤

All of my files are corrupted

I can't get through this part somebody help me,most especially the MsgBox code part , whenever I run ,a compile error displays.

Thanks so much...

thank god i've been trying to do this for like 5 hours and probably 4 shut downs and a tutorial that did the same as you but worse. gotcha a new sub bro thanks

THANKS FOR THIS VIDEO ITS REALLY HELP ME A LOTS AND LEARNED FROM IT "THANK YOU, THANK YOU.........

First, amazing code - many thanks. Second, like others here, running the macro as is got the result that a few folks posted here - one tab with just ONE line and then a second tab named but with no data. And that's it. Tried different columns, different number of rows, same thing. Tried stepping into the code, but with the input boxes that was hard. So here's my super lame work-around that made the code run like a charm - I commented out the Application.InputBox and hard-coded the range I wanted to run. So... Set SplitFld = Range("A2:A20000") Set Hdgs = Range("A1:J1") I don't know why this works, but then again, I don't know how the entire thing works and I certainly don't know about InputBoxes but maybe this helps some folks who were having the same issue I was having. I'll continue to noodle this and will follow up if I can figure it out but even if I can't, it's a super easy workaround on a really useful Macro.

bro u not explaining it well

Thank you very much and Merry Christmas!

I don’t have a cursor in the text box and it chooses the size of text box please can someone help

how can I capitalise existing data it is too much to do like this

Brilliant, exactly what I was trying to do, and so simple, my Spreadsheet has over 150,000 rows and it works perfectly. Thankyou very much

THANK YOU VERY MUCH

That’s really cool!

Brilliant!! Thank you! I used your other videos to create something and got the N/A error. I knew it could be fixed but couldn’t remember how it was done..

Clear and concise!. One question, can this be saved when new additions in the excel file are added?

Thank you. This is exactly what I’m looking for.

I Cannot get the picture to fill the entire page in word for mac.

thnank god... i needed this vid

YOU SAVED ME OMG THANK YOU SO SO SOOOOOOO MUCH

here is a subscribe sir

great video, thank you!

Is there away to hide the "sum, average" headings?

HI Chester. I have some trouble including in my path the date of my invoice. In other words I wnat to save the Invoice number followed by the date, but i do not seem to get the correct syntax when I tell PDF writer to get the date from my cell. I know that i can use the 'Format' function for the date and it will work. But I do not want this. I rather will have the date saved in a variable and then use the value stored in the date variable to include in my path. i want to do this since I want to use the date variable for other sub-routines that i want to run. Any suggestion on the correct syntax that the PDF writer will allow.? Tahnks martin (South africa)

DID NOT work. Windows 11 home.

Thank you so much for this video! I have a question, I’m a student studying abroad and use two currencies-JPY and EUR. My main currency is JPY, but there are times I use my EUR debit card for purchases, and since I’m spending in JPY, I find it much easier to track everything in one currency. (in my case JPY) In the past, I’ve manually converted my home currency (EUR) to JPY, but the exchange rate fluctuates, making my balances inaccurate over time. I’ve tried different Excel formulas to make this process automatic, but I keep encountering errors. Could you make a guide on how to set up a spreadsheet or formula that handles currency conversion dynamically, considering the fluctuating rates?

thank you

Any reason why i can restore files with this command in selected folder, BUT the restored files CANNOT be opened.... i tried on 3 different pc win 10/win 11.... i deleted a pdf on puropose, then i tried to restore it. it goes to the selected folder, with the right file name. when i try to open it i get error. same with bpm, word and excell files...

Thanks you soo much ❤

Hey mate, i have typed out a "Word" with a capital, now, knowing ive used that capital wrong, i need to change to "word" for the entire document.... is there a way to do this? when i use the replace function it doesnt work for grammar

Thank you

Thanks!

When I did this it turned my percentages into decimals, how do I stop that?

Great job! It is clear and to the point!

YES! I DID IT! Many, MANY Thanks!

It worked for me, i just did it,thank you sir.

Thank u for this nice video