Hi Mynda Just following on from the previous post, I've done two folder combines as you suggested and did the separate transformations on each samp...
Many thanks Mynda.
Hi Mynda That's brilliant! Just one further question. I noticed that you had converted the original form into a table and then split the table into...
Hi Catalin Thanks for your response. I was trying to re-use the queries in a new workbook but change the sample file and the combine query function...
Hi Mynda Thanks, that's great. Tim
Hi Mynda Thanks for your response. I've followed your suggestion and set up conditional formatting based on 'Format Only Cells That Contain'-->c...
Hi Mynda Thanks for your response. I've already used the custom function with the formula =$E$12<=$D$2. This works well at restricting the total...
Hi Mynda Thanks for your response. Tim