I'm trying to copy and paste only the first 6 digits for a cell to another macro written excel file.
Above my current code.
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.