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
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