| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reutrn a value from a cell in each workbook filename from another
hi guys. i was able to make the first step, thanks to the discussion
groups... i was able to make a list of all files located in a folder in a single sheet (column A). now, i need to find, in each file from column A, a certain cell within the file... like this... in each file, i have a cell that i write as "GRAND TOTAL", and i need to get that value, which is the one right beside the grand total cell. i'm trying to make a summary of all computation files in that folder for reports, wherein i just open the summary file, and everything will be there.... how to do this?i can't figure this out... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELL("filename") doesn't work on shortcut workbook link? | Excel Worksheet Functions | |||
| vba, get filename of this workbook | Excel Discussion (Misc queries) | |||
| Workbook name in VBA doesn't match filename.xls | Excel Discussion (Misc queries) | |||
| Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
| My workbook filename | Excel Programming | |||
Threaded Mode
