Hi all,
Ok, so I have two worksheets(index and master). When the user inputs data, the program creates a unique PR number automatically that has 3 letters, then 5 numbers. (eg. STL39849). I did this by concactenating two other cells. I want to copy and paste this PR number so I can paste it in another area, but a simple copy and pastespecial does not work for the result of a concatenated value. Just to reiterate, the PR number is a value created by concatenating two cells. I want to take this value and paste it in another location. Any help is appreciated!
Ok, so I have two worksheets(index and master). When the user inputs data, the program creates a unique PR number automatically that has 3 letters, then 5 numbers. (eg. STL39849). I did this by concactenating two other cells. I want to copy and paste this PR number so I can paste it in another area, but a simple copy and pastespecial does not work for the result of a concatenated value. Just to reiterate, the PR number is a value created by concatenating two cells. I want to take this value and paste it in another location. Any help is appreciated!