dave123
08-06-2011, 08:14 AM
Hey,
My goal is to have a spreadsheet in table form which each row gathered its data from a different workbook. ie.
Date Value1 Value2 Value3
a b c d
e f g h
i j k l
the values a,b,c,d are in one workbook while e,f,g,h in another etc. Also, the values are not beside eachother in the workbooks but in the same cells workbook to workbook.
the workbooks are automatically downloaded into the same folder from a database so it would be nice if the macro could identify a new workbook in the folder and add it to the next row of the table worksheet shown above say i,j,k,l.
if you have any ideas which could help me out that would be superb.
Cheers,
Dave
My goal is to have a spreadsheet in table form which each row gathered its data from a different workbook. ie.
Date Value1 Value2 Value3
a b c d
e f g h
i j k l
the values a,b,c,d are in one workbook while e,f,g,h in another etc. Also, the values are not beside eachother in the workbooks but in the same cells workbook to workbook.
the workbooks are automatically downloaded into the same folder from a database so it would be nice if the macro could identify a new workbook in the folder and add it to the next row of the table worksheet shown above say i,j,k,l.
if you have any ideas which could help me out that would be superb.
Cheers,
Dave