Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-29-2011, 05:37 PM
KIM SOLIS KIM SOLIS is offline How to merge two cells from sheet1 to one cell in sheet2 in next sheet Windows XP How to merge two cells from sheet1 to one cell in sheet2 in next sheet Office 97
Novice
How to merge two cells from sheet1 to one cell in sheet2 in next sheet
 
Join Date: Sep 2011
Posts: 29
KIM SOLIS is on a distinguished road
Default 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
Attached Files
File Type: xls Query106-Merging two cells to one in next worksheet.xls (22.0 KB, 16 views)

Last edited by KIM SOLIS; 10-29-2011 at 05:43 PM. Reason: additional query added
Reply With Quote
  #2  
Old 10-30-2011, 04:19 AM
Catalin.B Catalin.B is offline How to merge two cells from sheet1 to one cell in sheet2 in next sheet 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
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
  #3  
Old 10-30-2011, 08:15 AM
KIM SOLIS KIM SOLIS is offline How to merge two cells from sheet1 to one cell in sheet2 in next sheet Windows XP How to merge two cells from sheet1 to one cell in sheet2 in next sheet Office 97
Novice
How to merge two cells from sheet1 to one cell in sheet2 in next sheet
 
Join Date: Sep 2011
Posts: 29
KIM SOLIS is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 10-30-2011, 08:30 AM
Catalin.B Catalin.B is offline How to merge two cells from sheet1 to one cell in sheet2 in next sheet 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
Catalin.B is on a distinguished road
Default

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
Reply With Quote
  #5  
Old 10-30-2011, 08:32 AM
Catalin.B Catalin.B is offline How to merge two cells from sheet1 to one cell in sheet2 in next sheet 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
Catalin.B is on a distinguished road
Default

And this is your file...
Reply With Quote
  #6  
Old 10-30-2011, 04:22 PM
KIM SOLIS KIM SOLIS is offline How to merge two cells from sheet1 to one cell in sheet2 in next sheet Windows XP How to merge two cells from sheet1 to one cell in sheet2 in next sheet Office 97
Novice
How to merge two cells from sheet1 to one cell in sheet2 in next sheet
 
Join Date: Sep 2011
Posts: 29
KIM SOLIS is on a distinguished road
Default

Hi Catalin, Got it and thanks a lot again
Reply With Quote
  #7  
Old 10-30-2011, 11:14 PM
Catalin.B Catalin.B is offline How to merge two cells from sheet1 to one cell in sheet2 in next sheet 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
Catalin.B is on a distinguished road
Default

You're wellcome
Reply With Quote
Reply

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 merge two cells from sheet1 to one cell in sheet2 in next sheet 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 04:42 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft