Hollywoood
Board Regular
- Joined
- Aug 11, 2011
- Messages
- 53
Hi all,
Looking for a little help on this. I have seen similar types of queries but a little more involved and my knowledge of excell scripting is not sufficient to dumb them down.
Essentially I am looking to save single worksheet work books in a directory and have a master sheet that will total various single cells across all of those sheets. the master sheet would be saved in a separate area to avoid any potential cyclical references etc.
Is there a simple enough routine that would simply look to a directory on my PC, then sum all values of a cell, lets just say A1, of all of the sheets present in that directory?
Thanks so much in advance
Looking for a little help on this. I have seen similar types of queries but a little more involved and my knowledge of excell scripting is not sufficient to dumb them down.
Essentially I am looking to save single worksheet work books in a directory and have a master sheet that will total various single cells across all of those sheets. the master sheet would be saved in a separate area to avoid any potential cyclical references etc.
Is there a simple enough routine that would simply look to a directory on my PC, then sum all values of a cell, lets just say A1, of all of the sheets present in that directory?
Thanks so much in advance
