Forum

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

Hi Miguel, What type of file is it? If you don't already know the country of origin, I don't know how you can tell for sure by looking at the file...

Hi Guanyu, Use the Custom Lists as I described to sort your pivot table. By the Way - to upload a file : Under the box where you type your repli...

Hi Guanyu, You can create a custom list and sort your pivot table by that. File -> Options -> Advanced -> Edit Custom Lists and crea...

Hi, I'm having trouble understanding what you want to do but I think it is something like this (Source as table, Col as text, Value as text)=>...

Hi Mikaela, I'm afraid there's no attachment. Did you click on the Upload button? Regards Phil

Hi, It would be much easier if you supplied a detailed example with data in a file. A couple of lines taken out of context are hard to relate to. ...

Hi Terri, Change the chart to a 100% Stacked Column. Regards Phil

Hi Florence, Can you please supply some sample source files for your query to load? Phil