Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add file name somewhere in worksheet?
Hi. I have a folder of files that I am consolidating into 1 file 1, sheet.
When I consolidate into 1 file, can I append each row with the file name? Each file is a template, so it has the same # of columns but may have different # of rows. So, for instance, I'd like to put the name of the file in column Z of each populated row, so when it consolidates into the single file, I see the file name for each and every line. Any ideas? Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set up a worksheet name as file name | Excel Discussion (Misc queries) | |||
Worksheet to new file | Excel Discussion (Misc queries) | |||
copy part of a worksheet into a worksheet in the same file/keepi. | Excel Worksheet Functions | |||
Saving worksheet in new file with date AND cell value as file name | Excel Discussion (Misc queries) | |||
open file dialog-select file-import worksheet | Excel Programming |