New Sheets for hyperlinked files
I have a macro that will open a list of hyperlinked files, now i want
to compile information out of those files into a master file. The file
names all start with the job number (e.g. Job3*.xls), and I'd like to
make a new sheet for each job number. I'm pretty new to this, so I
don't even know if this is possible. Once the sheets are created, I've
got the data pulling macro working, but right now I have to create the
new sheets manually first. Thanks
|