ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Merged cells (https://www.excelbanter.com/excel-worksheet-functions/217330-merged-cells.html)

[email protected]

Merged cells
 
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

joel

Merged cells
 
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



All times are GMT +1. The time now is 09:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com