Forum

Hi Mike, Thanks for taking the time to look at this again. I can see what you have done differently to my original query. As mentioned mine worked ...

Hi Mike, Thanks for the reply and the file. I was trying to avoid the need for the users to launch the query editor. I wanted to pick the value up ...

Thanks Phil that works perfectly. Just for others the {0} specifies the column number. The first column in the table is zero. Cheers Bax

Hi Mynda, Thanks the dynamic list has resolved my issue. I have not used this functionality before. I will have a play Thanks again Bax

Hi, Please find the workbook attached. The query is returned in the table in the Sales_Data sheet. The source data is in the Sales sheet. I crea...

Hi Mynda, Thanks for pointing me in the right direction. I have managed to create the chart as required (see attached). It was a bit fiddly...

Hi Mynda, I wasn't given any data just the image of the chart that I attached to my last post. I was told that it was done in Excel and asked if I ...

Hi Catalin, I am not sure adding the code in your example will help me solve my issue above but it will be really really useful for lots of other t...

Hi Catalin, Thanks for the response. I did think about something along the lines of what you have said however I want the user to be able to have p...