M
mckrs
Hello,
Does anyone know of a function (if this is even possible in Excel),
that imports a file handle (name of the source file) & displays
it in an adjacent cell every time that I cut & paste data from that
file into Excel.
For example, I copy a text string from the text file 'data.txt'
into the clipboard, I bring up the Excel Worksheet, paste the
data into a cell & the cell in the same row, next column over
automatically populates with the path & filename of the origin
('C:\My Documents\data.txt' in this case).
Any help on this is thoroughly appreciated.
Thanks!
Does anyone know of a function (if this is even possible in Excel),
that imports a file handle (name of the source file) & displays
it in an adjacent cell every time that I cut & paste data from that
file into Excel.
For example, I copy a text string from the text file 'data.txt'
into the clipboard, I bring up the Excel Worksheet, paste the
data into a cell & the cell in the same row, next column over
automatically populates with the path & filename of the origin
('C:\My Documents\data.txt' in this case).
Any help on this is thoroughly appreciated.
Thanks!