Hey all,

I'm attempting to consolidate a ton of data from multiple workbooks into one spreadsheet. Unfortunately it's been a while since I've done any programming and it was never with VBA... I think I can struggle through data selection/copy process but I'm not sure how to access multiple workbooks.

The data I want to copy from the workbooks is always in the same cells, which helps. If anyone could give me some quick pointers on how to start this macro up and access other workbooks I'd really appreciate it.


Secondary problem: One of the sections of data I'm copying is a column of data points which would correspond with the y-axis of a graph. The x-axis values are a couple columns over, but I'd like to only copy the y- data to save space in the other workbook. The problem is that the range of the x- data will occasionally extend to larger values without changing the rest of the values. I would need the macro to "see" which x- value the y- data begins at and place it accordingly. That was extremely hard to understand so I'll try illustrating:

Data Source 1:
x y
10 1
9 3
8 2
7 3
6 4

Data Source 2:

x y
9 2
8 1
7 3
6 4
5 5

What I'd Like To Construct:

x y1 y2
10 1
9 3 2
8 2 1
7 3 3
6 4 4
5 5

Hopefully that makes it a little more obvious. I'm assuming I'll just have to have the macro look to see what value the data begins collection at and then have it match up to the proper row in the destination table.

I'll be scanning some intro VBA material I saw posted in the stickied topic as well, hopefully that will help. Thanks for any help on this!