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. I will attach a sample of the 2 worksheets and the master sheet is has to be copied to, sorry but its doing my head in
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. I will attach a sample of the 2 worksheets and the master sheet is has to be copied to, sorry but its doing my head in