Hi all,
I'm really stuck here, hoping you can help me with this!
I have a table in Excel and macros to autofilter the table, based on my various needs. Often, this table will bring back multiple results, but for the same individuals (e.g. four rows for Joe Bloggs and three rows for Jane Smith). In order to differentiate them, I am using a formula in Row A which gives each individual an index number for all of their rows (e.g. if Joe Bloggs has four rows, all four rows will have the same number).
What I am trying to do, is have the macro automatically generate an email to each individual including all of their results. I know how to generate the email, but I'm stuck on creating a loop in my code that will do the following:
Loop through a certain amount of numbers (1 to 50 lets say), to check if that number has been returned in the filtered results for row A.
If yes, it will proceed to filter the table to only include that number, execute the email generating macro, then remove this new filter to continue the loop and check for others.
The end result for the previous example would be two emails generated, with one including Joe Blogg's 4 rows and the other with Jane Smith's three rows.
Please let me know if there are any questions you have that may help me resolve this!
Thanks in advance,
Guy
I'm really stuck here, hoping you can help me with this!
I have a table in Excel and macros to autofilter the table, based on my various needs. Often, this table will bring back multiple results, but for the same individuals (e.g. four rows for Joe Bloggs and three rows for Jane Smith). In order to differentiate them, I am using a formula in Row A which gives each individual an index number for all of their rows (e.g. if Joe Bloggs has four rows, all four rows will have the same number).
What I am trying to do, is have the macro automatically generate an email to each individual including all of their results. I know how to generate the email, but I'm stuck on creating a loop in my code that will do the following:
Loop through a certain amount of numbers (1 to 50 lets say), to check if that number has been returned in the filtered results for row A.
If yes, it will proceed to filter the table to only include that number, execute the email generating macro, then remove this new filter to continue the loop and check for others.
The end result for the previous example would be two emails generated, with one including Joe Blogg's 4 rows and the other with Jane Smith's three rows.
Please let me know if there are any questions you have that may help me resolve this!
Thanks in advance,
Guy
