PDA

View Full Version : Copying value from multiple workbook to one after every 60 mins



royal99
02-25-2015, 11:48 AM
I have list of name in a column D, list of names are dynamic and in column M I have some values opposite the name columns. Like that I have some 9 to 10 files.


I want to copy all the names in column C from all the workbook and paste in a workbook call "Consolidated" one below the other, now the tricky part


the values which I have in all the workbook in column M will be copied and pasted adjacent to name column of the consolidated file,


I all the above the workbook the value will change after an hour, so now I have to copy only the value of every workbook and paste in next column of previous pasted value.


so after third hour I will hit macro and values from all the workbook to be pasted in third column of consolidated file.


Name Hour 1 Hour 2 Hour 3 Hour 4 hour 5 hour6
Joan 23 44 77 22
Mike 46 66 23 25
Tracy 32 33 48 26
lemon 52 22 26 31
David 22 11 14 11
Nicole 21 1 12 10

royal99
02-25-2015, 11:52 AM
Ignore my previous attachment