How to merge two cells from sheet1 to one cell in sheet2 in next sheet

KIM SOLIS · #1 10-29-2011, 05:37 PM

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

Catalin.B · #2 10-30-2011, 04:19 AM

=Sheet1!A4&"-"&Sheet1!B4
instructions can be set only with a macro, like:

Code:

Private Sub Worksheet_Activate()
MsgBox "your instructions here"
End Sub

and this message will pop up every time the sheet with this code in it is activated

KIM SOLIS · #3 10-30-2011, 08:15 AM

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

Catalin.B · #4 10-30-2011, 08:30 AM

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

Catalin.B · #5 10-30-2011, 08:32 AM

And this is your file...

KIM SOLIS · #6 10-30-2011, 04:22 PM

Hi Catalin, Got it and thanks a lot again

Catalin.B · #7 10-30-2011, 11:14 PM

You're wellcome

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