Forum

Hi Jonathan, Please supply your workbook so we don't have to recreate everything. Thanks Phil

Hi, Please supply your workbook with the code so we can test things in context with your data. Also, I don't know what you mean by its run time ...

Hi Reshera, What website are you trying to get this from? Phil

Hi Robert, yes and do the same for the B column: =AND($B2=TRUE,OR(RIGHT($A2,3)=".wa",RIGHT($A2,3)=".oa",RIGHT($A2,3)=".sa")) Cheers Phil

Hi Chadi, These articles describe how to do what you want There are also a few topics on scraping in this forum where I've written code whic...

Hi MM. Excel uses its own internal names for the sheets e.g. Sheet1, Sheet2. If you change the names on the sheet tabs in your workbook, these int...

Sorry, Access is not my strong point so I'm not sure what to suggest to make it work for you. Regards Phil

Hi Robert, The formula you need to make the text red under those conditions is: =AND(B2=TRUE,OR(RIGHT(A2,3)=".wa",RIGHT(A2,3)=".oa",RIGHT(A2,3...

Hi Maurizio, Give this a go. Regards Phil

Hi Robert, The syntax for OR is =OR(Condition1, Condition2) so something like =OR(A1=123, B1="xyz") Your first OR formula is OR($A2,A2="wa") ...

no worries

no worries. 🙂

Thanks Adrian. Yes you can attach the workbook (or sheet). Do you want it sent as an Excel file or as a PDF? Phil