excel multiple files saved in 1 file

  • Thread starter Thread starter seanyeap
  • Start date Start date
Just adding on to this, help!?!?

Hey everyone!

I'm doing something completely similar to what this person had to accomplish. However, how can I accomplish this with multiple workbooks with different sheet names. They all come from the first sheet, they all just happened to be named differently. Is there a way to just call out the first sheet? Any help would greatly be appreciated!! Thanks so much!!

Mike


seanyeap said:
Dear Dave Peterson,
Yep, it was typo error, anyway,thanks a lot.

Regards,
sea

--
Click to expand...
 
Thanks that helps out a lot!!

Except 1 more thing, instead of copying a range, I want to copy 4 specific cells out of each worksheet and put those into rows of a new workbook or worksheet. Is there a way that I can manipulate this code to do that thanks!
 
I would use a database in this situation and that's where things are ending up. I was given 2500 files all entered into excel workbooks. It was my job to pull out the important information for the database by any means possible. I wasn't about to sit down and manually type them in, so that's why I came here.
 
Back
Top