Forum

You're welcome.

Hi Rhee, Are you always looking for 3 factors? Will the total always be 9? When you say 'continuously generate' are you looking to find all facto...

Hi Rajsha, I wrote a post on interacting with webpages which may be of help to you Web scraping filling in forms But if the website uses...

Hi Sammy, Without seeing your workbook I can't give you my 'best' answer. I don't know what data you are trying to copy. Perhaps you could form...

Hi Rajsha, It sounds like you are trying to click a button on a web page to go to the next page and get the data on that next page. I'll need to...

Hi Rhee, If the value in B5 is fixed, then you are limited to the 'random' numbers you can use to in ColA that add up to the sum in B5. I don't se...

🙂 you're welcome

🙂 You're welcome.

Hi Maruizio, See attached workbook for working code. You'll need to modify it to use your own data validation list. Regards Phil

Hi Nelson, Try the attached file, no VBA needed. Regards Phil

Hi, I'm not sure where these spaces are that you refer to, you haven't been clear. But if you are trying to remove spaces from the start and end o...

Hi Lydia, If you end up with 50 sheets you can save each one as a workbook using the attached VBA. Sub SaveSheetsAsWorkbooks() Dim ws As Work...

You're welcome, glad you got it sorted out. Phil

Hi Sunil, To attach a file click on the Attachments button below where you type you qs. Then Add Files-> Start Upload. Phil

Hi Andy, The cell with the Barcode function was set to Text format and the font was Bold. Having it Bold mean the bars weren't being read properly...