#1
|
|||
|
|||
VBA to gather data from one workbook and pasting it in a data set
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 |
#2
|
||||
|
||||
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] |
Tags |
excel 2010, macro, vba |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
sorting data while in a protected workbook | Andy Francis | Excel | 0 | 06-06-2015 01:35 AM |
data entered in one workbook should be updated in other relevant workbook based on the date | vedha | Excel | 0 | 04-24-2015 08:45 PM |
How to share cell data between tabs of workbook? | littlekeith | Excel | 1 | 03-23-2015 06:21 AM |
Workbook data Names in VBA are string only? | BobBridges | Excel Programming | 7 | 01-29-2014 09:02 AM |
macro to transfer data from one workbook to another workbook | virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |