| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
extract certain values from multiple workbooks into a new file
See
http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message ... Hi, I'm hoping somebody could help me with this problem. It's pretty simple, but an Excel script would be the first for me, although I'm not a complete newbie to scripting. I could use some reverse engineering insight. Ok, here is my problem. I have multiple files, all based on the same template. I'd like to create a new file with values from I39 and I40, which would include the file name, and these two values in rows. If it makes it any easier, I've extracted the file names by piping DIR into a file, so the script could use those as file name index. A big thanks for all help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract multiple values from array | Excel Discussion (Misc queries) | |||
| extract data from multiple workbooks | Excel Discussion (Misc queries) | |||
| extract from multiple workbooks in a folder | Excel Discussion (Misc queries) | |||
| Search & extract from multiple workbooks | Excel Programming | |||
| How do I extract cells from multiple workbooks | Excel Discussion (Misc queries) | |||
Threaded Mode
