Forum

Hi Maurizio, glad you got it figured out. Regards Phil

Hi Maurizio, I'm not clear on what it is you are trying to do. There's no code in your file and the code as posted does not work. To get the te...

Crossposted here excel - How Can I Extract list of prices from website using VBA? - Stack Overflow Please read these Forum Rules

Sorry Mark, that is the way the data is displayed in a visual like a table. Each row shows data for each column. Regards Phil

Hi Farshad, Why do you want to use List.Accumulate for this? You can just append (combine) the tables to create 1 table. = Table.Combine({Table...

Hi John, Can you provide your query so we can see what it is trying to do? Regards Phil

Hi Arun, Please start a new topic when you ask a new question. Please don't add a new question to the end of an already answered topic. Please ...

Hi Arun, Sorry we don't do homework/assignments for people. We encourage you to learn to solve the problems yourself. Looks like you'll need to u...

Hi Patrick, You can get the first part of the address with this =IF(IFERROR(SEARCH(" Ste ",C2),0)>0,LEFT(C2,LEN(C2)-(LEN(C2)-SEARCH(" Ste ",C...

No worries Tamara

OK I think I know what you mean. The code you've entered is interfering with my code that checks the selection from the validation list. You just ...

Hi Tamara, Running the code in the last file you provided does not generate any errors. Could you please describe in detail exactly what it is y...

Hi Tamara, You need to add a 'trap' to check for the cell that is being changed. As you want to check the value in C6 when it is changed, you need...