Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Put file name in column
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format column to link file names in that column | Excel Discussion (Misc queries) | |||
ONE xls column to file? | New Users to Excel | |||
insert a blank column between each column in a data file | Excel Discussion (Misc queries) | |||
need to export row as csv file with column e plus .bom as file name | Excel Discussion (Misc queries) | |||
How do I change *.CSV excel file to column seperated file? | Excel Discussion (Misc queries) |