Hi, I wonder whether someone may be able to help me please.
I'm attempting to put together a script which in simple terms finds the 'Highest and Second' highest activity and associated FTE for a given sub group.
To be more specific:
- On the "Slide 1" sheet look at the values in column J starting at row 7 until blank;
- For each value, then search the "All Monthly Direct Activities" sheet in column C for the same value, excluding the 'Subtotal' rows;
- Where a match is found, compare all the values in column E for that sub group;
- And Find the highest and second highest figure;
Once these are found copy this figure and associated value in column B and paste onto the "slide 1" sheet.
I have posted on ExcelForum here http://www.excelforum.com/excel-programm…st-figures.html and did receive some help as you will see but I still have an outstanding issue.
I'm not particularly well versed in writing VB, but I've been working with the code to see if I can get this work, which I have been unable to do.
I have attached a file which may perhaps provide a greater detail than my description of the problem containing the 'Source' and 'Destination' sheets.
I just wondered whether someone could possibly look at this please and feel they may be able to help
Many thanks and kind regards