Hi,
I'm trying to copy and paste only the first 6 digits for a cell to another macro written excel file.
[ATTACH=CONFIG]72750[/ATTACH]
Above my current code.
[ATTACH=CONFIG]72752[/ATTACH]
Data i'm trying to copy and paste.
i only want to copy the 1st 6 digits.
Right is the data source and left is what i'm getting now.
Possible to write a code that allow me to only copy the first 6 digits and paste into another sheet.
Thanks in advance.