Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Suggestion to add ability to merge non-adjacent cells in Excel.
I would like to see the ability to merge non-adjacent cells. In essence, I
am talking about tying two or more cells together so that they behave like the same cell: you would be able to change data in EITHER ONE and it will automatically show up in the other cell AND vice-versa. -- Doyle_D ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
|
|||
|
|||
Hi Doyle,
Even merging two adjacent cells do not operate like that. The only way you would be able to effect that change quickly would be with a Change Event macro and would apply to constants only not to formulas. I did not check as constant in my example. http://www.mvps.org/dmcritchie/excel/event.htm#change Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) 'to install -- right-click on the sheettab of the sheet to ' be used in and choose 'view code'. Paste this Worksheet ' event macro into the module. '-- change to Col B changes value in Column G to that of B '-- change to Col G changes value in Column B to that of G On Error GoTo ErrHandler Application.EnableEvents = False If Target.Column = 2 Then Cells(Target.row, 7).Value = Target.Value ElseIf Target.Column = 7 Then Cells(Target.row, 2).Value = Target.Value End If ErrHandler: Application.EnableEvents = True End Sub --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Doyle_D" wrote in message ... I would like to see the ability to merge non-adjacent cells. In essence, I am talking about tying two or more cells together so that they behave like the same cell: you would be able to change data in EITHER ONE and it will automatically show up in the other cell AND vice-versa. -- Doyle_D ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#3
|
|||
|
|||
|
#5
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
Merge using Excel 2002 and Hummingbird Docs Open 3.9.0 Build 199 | Excel Discussion (Misc queries) | |||
How do I do an excel merge like a word mailmerge with another exc. | Excel Discussion (Misc queries) | |||
Serious Mail Merge Problem | Excel Discussion (Misc queries) | |||
Extract Data for Mail Merge | Excel Discussion (Misc queries) |