Pulling data from yyyyMMMMdd.xls

M

Mike Punko

My file names are as follows yyyymmmmdd.xls - 2005August21.xls,2005August22.xls

Presently the data (E5:E33) then (H5:H49) is copied then pasted
(Value+Transposed) into '2005 Daily Production.xls' August! H25 then AL25
(Row 25 is the row which falls on August22 date line that's why the data is
pasted Transposed.) Is there a function that can pull the data based on a
entered date into the '2005 Daily Production.xls' worksheet?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pull data from yyyymmmmdd.xls 1
How to pull in data from rows and columns if there are blanks? 0
Automation of copy/pasting data and retrieving results 0
Pulling data from a website 1
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
Set destination sheet based on variable and paste data assistance 13
Collecting data from multiple files 3
pull data from multiple sheets with formula referencing a tab name 5

Top