Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pulling data from yyyyMMMMdd.xls
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions |