Microsoft Office Forums - View Single Post - [Solved] How to merge two cells from sheet1 to one cell in sheet2 in next sheet

Thread: [Solved] How to merge two cells from sheet1 to one cell in sheet2 in next sheet

View Single Post

Old

10-30-2011, 04:19 AM

Catalin.B

Catalin.B is offline

Catalin.B uses Windows Vista

Windows Vista Catalin.B uses Office 2010 32bit

Catalin.B uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

Catalin.B is on a distinguished road

Default

=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

Reply With Quote