Copy cell range data for email

[ipbr21054]

Hi,
I have a worksheet which when you enter 7 characters the calculator does its magic & then returns a much longer number.

I havent seen anything like this before but below is some of the code to explain to you what its all about & hoping somebody will understand what i have here as im lost on how to explain it.

=CONCATENATE("*",UPPER(E7),UPPER(E6),UPPER(F6),UPPER(G6),UPPER(H6),UPPER(I6),UPPER(J6),E19,"FF",E23,"*")

Brief example of what i see.
You input 7 characters on sheet 1 & the lookup database is on sheet 2.
Database Column B is numbers from 0-42
Database Column A is 0-9 followed by A-Z followed by 7 character symbols.

I need to be able to copy the data of which is that long number 18 characters & there is 4 of them,paste these values into a excel sheet so i can then email it.

Any member know of this code & might be able to help.

Thanks

 

[ipbr21054]

Just a thought.
Can this Concatenate code be put on a button ?

If so could we then use the same code in use at present,put on a button & when you press the button it would calculate the long code & put on Sheet 3 which i will then email the customer.

I can supply code,cell ref etc to assist you.

Thanks