Forum

No worries. If there were prizes for badly formatted data exports then we'd have a contender. Phil

Hi Christine, Your image shows the workbook embedded in a web page so I'll need the address of that web page and the embed code you are using from ...

Hi Yousef, I've used the code I wrote in this post and modified it slightly to do what you want. I also used the RangetoHTML function from Ro...

Hi Kaushik, As Purfleet said this has been covered many times, did you use the Search function at the top of the site? Searching for 'email' in th...

Hi Miguel, If you know the file is from Spain then import it using the Spanish (Spain) locale es-ES? Likewise for the other countries. Phil

Hi Scott, the workbook doesn't quite match up with the pictures or your description,so it's a little tricky to follow and I don't want to write cod...

Hi Florence, That data dump is in a really bad format for working with! I'm sure it's not you fault but it would make lives so much easier if data...

no worries 🙂

Hi Jacek, Try the attached query. It works in the sense that it gives you the desired table, but relies on filling down missing values for: Top...

Hi Scott, Please supply a workbook with data, we can't write any code to affect that data without it. Regards Phil

Hi Mikaela, There's no code in the workbook you supplied? I've taken the code from this post and put it in your workbook, in the Sheet1 cod...

Hi Guanyu, Yes the custom list will be stored in the workbook so if it's opened elsewhere you (or someone else) can sort using that CL. However,...

No worries 🙂

Hi Salim, Your screenshot shows 2 Excel workbooks side by side but that doesn't really relate to using VBA. To refer to 2 worksheets or workbook...

Hi Bax, Please supply your workbook so we don't have to recreate the data and query. Phil