Can Excel search for workbook data in a Windows folder?
So here's the skinny. I have a workbook(#1) that I populate with Data from a
dozen or so different workbooks (A-Z). All of this dozen workbooks (A-Z) are
formatted the same and the data I need is in the exact same place for each
workbook.
A new workbook (just pick a letter of the alphabet) is generated once a day
and saved in the same Windows folder (STUFF).
Can I get #1 to search STUFF for folders A-Z and populate itself with the
data I want?
|