Search results

Hi Guys, I hope you can help. I have a macro which searches two saved workbooks for a matching reference and creates a new worksheet containing all of the matches found. This works fine What I want to do is call a simple macro that adds a pie chart to the active sheet and references a...

Thanks Narayan I'll do that now Thanks for your help Lee

Sorry Hui, The call is not added in this code. I have tried to call several macros and I have also tried to paste in code between "next" and "end sub" but the next loop is interrupting anything that I try to do. I just wanted to know if anyonw had experienced a similar problem with the next...

Hi Hui Thanks for coming back to me. I'll be sure to follow your instructions in future. The problem is that when I try to call another macro by entering "call macroname" just before End Sub it fails. I have done this many times before but this is the first time I have had a problem. The...

Hi Guys, I hope you can help I have some code which works fine but doesn't fully complete the task at hand. I need to either add to this code or call another macro to complete the job. I'm struggling to do this. Each time I try I am failing. The last function of the code is a next loop and...

Thanks Guys, Thats great. Is there any way for this sheet to flag ties? Thanks again Lee

Hi, I hope you can help. I have a list of sales records and I would like to find the 1st, 2nd, 3rd highest values from this list and return the salespersons name. I know that I can use INDEX&MATCH formula along with LARGE but I am struggling to get this working. It feels as though it...