Copy/Paste Result of Concactenated Cell

[keeper10]

Hi All,

So I have to worksheets (History and Flat). I have created a unique PR number in the History sheet using CONCACTENATE. The problem I am now running into is copying this value and pasting it into the Flat sheet. I feel like the solution to this may be fairly simple. I would also like to only copy the last 10 PR numbers, but I can write that code. Hopefully somone can help me take the value that has been concactenated and paste it in another worksheet. Thanks!

 

[Andrew Poulsom]

What have you tried that isn't working?

 

[keeper10]

I tried a normal copy/paste but nothing happened (I just started writing in VBA so I thought it was worth a shot). Then I just tried setting the value of the cell to a variable to allow me to move it a bit easier, but I haven't figured that out yet. I concatenated the cells not within VBA, but in the cell itself. So I may go back and concatenate then copy/paste all in VBA. Any suggestions?