excel programming vba - Linking 2 cells with data

The UK's most regular instructor-led training courses.
Training information: excel programming vba · Excel training courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Linking 2 cells with data

Gurmit has attended:
Excel Advanced course

by - delegate Gurmit [3 posts] (2007 Mar 5 Mon, 14:03) Reply

I am trying to link 2 adjoining cells complete with data. I have tried via format cells > alignment but it is not working. Can anyone help ?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Linking 2 cells with data

by - trainer Amanda diamond contributer [1217 posts] (2007 Mar 5 Mon, 14:15) Reply

Hi Gurmit

What you would need to do is merge the two cells together, however, if you do this when both cells have data in them then not all the data is kept.

If you cut and paste the information from the second cell into the first cell, then select both cells and click on the merge button on the formatting toolbar (it is a white square with an 'a' and arrow pointing in either direction on it), this should allow you to merge (join) these two cells together and not lose any data in the process.

Amanda

RE: Linking 2 cells with data

by - delegate Gurmit [3 posts] (2007 Mar 6 Tue, 13:46) Reply

Thanks Amanda,, however I cannot seem to find the A symbol with the 2 arrows. Can you tell me how pls ?

RE: Linking 2 cells with data

by - trainer Amanda diamond contributer [1217 posts] (2007 Mar 6 Tue, 15:54) Reply

Hi Gurmit

The button is on the formatting toolbar - this is the toolbar that has the font, font size, bold, italics etc on it. If you can't find the button, you can also select the cells you wish to merge, then go to Format-Cells-Alignment, then check the Merge cells option near the bottom of the dialogue box and click OK.

Let me know if either of these things don't work for you.

Amanda

· How Small Businesses Profit from Outside Excel Training
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Customized Financial Excel Courses in London
· Advanced level training: Microsoft Excel and the Web
· Crazy Things People Have Done With Excel

Excel tip:

Trace Dependents / Precedents without the blue arrows

Rather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula.

View all Excel hints and tips