Hi,



I am currently trying to figure out a VBA to help me sort through data. I haven't started any code yet though. What I am trying to do is have a macro that will go through every hyperlink on one sheet that leads to different workbooks, pull a name and a line of data associated with that name, and put it back on the original workbook but under an "Email List" sheet. I would like the macro to post all data under one person, but keep a list of where that information came from. For example:

John Doe
Hyperlink 1:
Test data
Test data
Test data

Hyperlink 2:
Test data
Test data
Test data

All of the hyperlinks that I would like the macro to go through are in one column, however there are two hyperlinks that I would like it not to go through which will be in another column.

I can attach example workbooks if that would help in this process. Please let me know if this is possible!

Thanks,
lwbarnes

You will need to provide a workbook containing some representative data showing how the hyperlinks are set up, what & where the relevant data are, and how they are to appear on the output sheet.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]