| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Macro for updating the filename along with data
Hi All Excel Gurus
I have a macro, to copy data from several files to my master workbook. However, the data is of similar nature in all those workbooks, so it becomes difficult for me to identify the file from which data has been copied from. Is there a way, that when the data is being pasted in master workbook, in coloum A of all rows which have been copied reflects the full filename? Any help in this would be highly appreciable.
__________________
Regards Gaurav |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating data automatically using macro | Excel Programming | |||
| CELL("filename",a1) not updating automatically | Excel Discussion (Misc queries) | |||
| macro updating imported data and pivot tables | Excel Programming | |||
| Updating original data from vlookup screen (macro?) | Excel Programming | |||
| Macro to Open the Menu Data,Refresh Data,filename,import | Excel Programming | |||
Threaded Mode
