Greetings. I have a sheet of stats for 50 agents. in the end the sheet look like this:
image1.jpg
I would like to have it so when the email address on cell I is clicked, it will populate an email that will paste B2, B3:H3, (Selected Agent range here), B9:B12, C9:C12, D9:D12, E9:E12, F10:F12, G10:G12, H10:H12. So.. If I clicked on Agent 2, the email would populate with this pasted in the body:
image2.jpg
Am I asking the impossible or can this be done?
Bookmarks