looking for marco to pull information from different sheet

**zbyke** · 07-30-2013, 02:46 AM

I'm looking for a macro that will pull information from one file to another.

File1 is where all the information will go to, while File2 is where all the informations is coming from. The tricky part is the sheets in File2 are dates and in
DD MMM YYYY format, however I can always change those to make it easier if need be.

All cells are posting in File1 |SHEET1 or SHEET2 | cells BCD3 to BCD14

They will be pulling from File2| SHEET TODAYS DATE| cells BCD3 to BCD14 (which will post to sheet1) and BCD19 to BCD30 (which will post to sheet2).

Thanks for any and all help. I'm sure this is already on here somewhere but being on a government computer i takes days to do a simple search and even longer to click through every page number.

**zbyke** · 07-30-2013, 04:16 AM

I updated the question, I realized it made not sense at all.

**zbyke** · 07-31-2013, 02:33 AM

I got what I need except for getting the sheet name.

Please Login or Register  to view this content.

I'm not sure how to pull the cell data from file1 cell D1 and use it as the SHEET NAME that I'm trying to pull the information from. I have all the sheets in DD-MMM-YY and I have cell D1 data as "TODAY()".