Forum

Hi Mark, Did you try to create the GPD formula for the 2nd PT manually? You can create a GPD formula by clicking on the cell in the PT that you wa...

Hi Stephen, I can think of more than one way this could be done but without seeing your data I don't know which way is best. Please attach your wo...

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