Hi All,
I have a spreadsheet that is opening another spreadsheet. What I'd like to do is read the file name (Left side of decimal) that has been copied in a common cell reference, copy and paste the text to another cell in the other spreadsheet.
Spreadsheet 1-Copy from left side of decimal
cell A1: abc123.xlsm
Spreadsheet 2-Paste into A1
Cell A1; abc123
Hope that makes it simple enough to follow. Thanks...any help would be appreciated.
JR
I have a spreadsheet that is opening another spreadsheet. What I'd like to do is read the file name (Left side of decimal) that has been copied in a common cell reference, copy and paste the text to another cell in the other spreadsheet.
Spreadsheet 1-Copy from left side of decimal
cell A1: abc123.xlsm
Spreadsheet 2-Paste into A1
Cell A1; abc123
Hope that makes it simple enough to follow. Thanks...any help would be appreciated.
JR