Use the F(x) box at the top of the worksheet. Select the source data then
highlight the data in the F(x) box and copy (Cntl-C). Then go to destination
location and click on cell. Then paste the data into the F(x) box at top of
worksheet.

" wrote:

Hi
Any help
I have a workbook with 2 sheets
Sheet1 contains:
A B
1 Name1 12
2 Name1 12
3 Name1 12
etc....
Sheet2 contains A123 merged, B123 merged, etc...
I want to copy the values in A1 in sheet1 to A123 in sheet2, etc...
Any help
Thanks in advance
Jam