Advanced filtering is a great tool, unfortunately that functionality is not available on a shared workbook. It is not an option for me to change to a non-shared workbook.
Is there some code that could be added which would replicate that functionality?
Right, I am struggling. If anyone could take a look at the example book and make any suggestions that would be fantastic.
The five example lines on the retail master are user inputs and I have included the reworked 1 sheet with the attempt I made to 'drag' the information across.
In terms of...
Thank you for the responses, I will look into array functions and see if I can work something out.
Will return with an example workbook if I can't work it out, watch this space...
Hi Ninjas, I have indeed run multiple searches, of chandoo.org and the not so awesome rest of the web. I have not found anything that has helped yet but appreciate that I may not be using the correct search terms which is why I posted here.
For better explanation, please simplified version of...
Hi everyone, have been soaking up the excel awesomeness on this site for a few weeks now but am stumped on something that I can't find a pre-existing answer for.
Running 2010 on Windows 7
Problem-
I have a workbook with a few sheets, it is used to track the vacancies of my client and their...