| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting data from all files from a folder.
Hi,
I am using a formula such as =VLOOKUP(A18;'C:[NF1.xls]Sheet1'!$B$15:$F$41;3;FALSE)*((AND(C6='[Not Fişleri.xls]Sheet1'!$F$8))) to retrieve data from an excel file to my main working excel file. The referance data are in A18 and C6. The data in A18 is always the same but the data in C6 will differ for the range C6:Z6. I need to generelize this process, getting data from all files from within a folder (and retrieving data from a range of columns) via a macro process. Can you suggest a stucture for it? p.s.: I can be more spesific if asked... TIA J_J |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summarizing the data from all the files in a folder | Excel Discussion (Misc queries) | |||
| Open many *.tsv files in folder and import the data into Excel | Excel Programming | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Programming | |||
| Copy same data from all files in folder | Excel Programming | |||
![J_J[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
