Hi all,
I have a folder full of monthly documents (50 or so different files), and I need to add up cells C61 and C68 in all of them. The files themselves all have various names, but they are in template form so the data I need will be in the same place in all of them.
Is there a way to develop a formula that will go into all those files in the folder and quickly sum up those two cells?
Thanks,
Ernie
I have a folder full of monthly documents (50 or so different files), and I need to add up cells C61 and C68 in all of them. The files themselves all have various names, but they are in template form so the data I need will be in the same place in all of them.
Is there a way to develop a formula that will go into all those files in the folder and quickly sum up those two cells?
Thanks,
Ernie