#1
|
|||
|
|||
How to merge two cells from sheet1 to one cell in sheet2 in next sheet
Hi all,
Please advice how to merge two cells from sheet1 into a single cell in sheet2 of the same worksheet file. Please see attached Query106.xls. Also, how do i post a brief message box (for instruction purposes) to appear ever ytime the user clicks the sheet2 tab? Thanks in advance. Kim Last edited by KIM SOLIS; 10-29-2011 at 05:43 PM. Reason: additional query added |
#2
|
|||
|
|||
=Sheet1!A4&"-"&Sheet1!B4
instructions can be set only with a macro, like: Code:
Private Sub Worksheet_Activate() MsgBox "your instructions here" End Sub |
#3
|
|||
|
|||
Thanks Catalin for the reply. Can you please apply the formula in the sample .xls file in my query. I am getting an error when i pasted the formula as there is no A4 and B4 cells. Will appreciate too if you can show the message reminder when the user clicks the sheet2 tab. Good day
|
#4
|
|||
|
|||
you setup excel option to reference R1C1 style, thats why the formula will look different: (excel options-formula-R1C1 reference style)
=Sheet1!RC[-1]&"-"&Sheet1!RC |
#5
|
|||
|
|||
And this is your file...
|
#6
|
|||
|
|||
Hi Catalin, Got it and thanks a lot again
|
#7
|
|||
|
|||
You're wellcome
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Automatically change the value of one cell so that two other cells become equal | matthew544 | Excel | 5 | 09-18-2011 08:56 AM |
How can I fill the below emty cells with above cell data? | Learner7 | Excel | 8 | 06-28-2011 12:10 PM |
How to combine different cells data in one cell? | Learner7 | Excel | 1 | 07-28-2010 12:07 PM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |