correlating multiple excel forms into one

[kieranbop]

I'm currently having problems with correlating multiple excel forms into one.

The aim is to use vba with excel to have a user interface that lets me load 3 files for example, all files have same layout, headings but different details in their columns. My aim is to once I've selected via browsing for the files on the form, it correlates them all into one file then forces a save or a load of the "master" file as It were.


I've currently made the userform, but obviously lacking in code as I'm stuck where to even begin!

It will read all the files from row 2 down to whereever the row is next empty, store all that data into a custom class and then resd that class and write out to a plain excel file or a pre- prepared one with just the headings to make the "master file"


e.g.


Name Number
Kieran 1
John 2
Hope 3

Name Number
Ted 2

then master file would have

Name Number
Kieran 1
John 2
Hope 3
Ted 2

or something like that, can anyone link me to a thread around this sort of thing or help me get started and I can continue from their?

any help or direction on how to begin this would be greatly appreciated!