Subramanian
08-10-2016, 01:24 PM
Hi,
I am just working with below
i.e I will have a folder that will have say 10 files( all the files will have required data in fixed cell) that i will require data from cell A1, A2, A3 of all the sheet in single file.
and the above files will be overwritten with new file every day or even on same day as an update
Currently i made a 11th file in the folder with a formula (referring each cell by link)to pick the data in single sheet from each data file. But it does not work when user over write formula, same works only when i open and close the overwritten file.
Also tries recording macro but they same gives a very long code and will also not be accurate 10 files was an example folder may contain 70 to 100 files too.
Could some one please suggest a VBA to do all the above task automatically instead using a formula to refer a cell.
Thanks in advance,
Subramanian
I am just working with below
i.e I will have a folder that will have say 10 files( all the files will have required data in fixed cell) that i will require data from cell A1, A2, A3 of all the sheet in single file.
and the above files will be overwritten with new file every day or even on same day as an update
Currently i made a 11th file in the folder with a formula (referring each cell by link)to pick the data in single sheet from each data file. But it does not work when user over write formula, same works only when i open and close the overwritten file.
Also tries recording macro but they same gives a very long code and will also not be accurate 10 files was an example folder may contain 70 to 100 files too.
Could some one please suggest a VBA to do all the above task automatically instead using a formula to refer a cell.
Thanks in advance,
Subramanian