vba code to pull data from 2 worksheets to 1 mastersheet

[antz74]

I am stuck..........
I have 2 training spreadsheets with names, courses & completion dates in row format and I want to have a vba code that automatically pulls data from the 2 worksheets & puts it into the master training spreadsheet which is in column format. it has to first match the course and name , then place the date in the correct training course column & I want it to have a button so when I have finished entering in data in 2 worksheets , I just click a button and it automatically copies and pastes only the new data I have entered.

 

[Norie]

What do you mean by 'row format'?

 

[antz74]

What do you mean by 'row format'?

Sorry, I meant the dates are entered across the row instead of down in a column

 

[antz74]

bump