Merged cells

J

jamalhakem

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
 
J

Joel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy non merged to merged cells again 1
Copy non merged to merged cells 2
Copy paste non merged to merged cells 1
Receive data in column with pull down 2
Sum If function 3
add hyperlink using sheet names and cells(i,j) 3
Find a number in a column then return a value from another cell 2
Unique Count in Sigma Query 3

Top