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

		Microsoft Office Forums > Microsoft Excel > Excel
How to merge two cells from sheet1 to one cell in sheet2 in next sheet

10-30-2011, 04:19 AM

Catalin.B

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

Office 2010 32bit

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

=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

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:08 AM.