09-23-2011, 08:35 AM
|
 |
Freshman
|
|
Join Date: Sep 2011
Location: Washington DC
Posts: 26
|
|
Matching data from multipal workbooks to one Spread Sheet
|
Hello All,
I have been using the recorder to build my Macros and have only been using VBA for about 3 weeks. I am so very new to this so I bought a book by Mr. Excel and it has given me some great knowledge. But for this task I feel I just dont know where to start.
I have 10 workbooks with 11 worksheets we call attachments.
I have one big worksheet that has the same serial numbers as all the attachments in those workbooks.
What I am trying to do is create a Macro that picks the first Serial number in the big worksheet. Then looks into all of the 10 workbooks finds and copies all the data from the row of that attachement. Then Pastes the data to the end of the row in the big worksheet.
Im not sure if this is easy or hard and I am excited to learn how to begin.
Thank you for any help you can give.
|
|
Linear Mode
