Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking

Linking

ResolvedVersion 2007

Thu 5 Nov 2009, 16:37 Delegate Shaper said...

Shaper has attended:
Excel Intermediate course
Excel Advanced course

Linking

can i link workbooks where the change is in adding/deleting lines?

Mon 9 Nov 2009, 13:20 Trainer Simon said...

RE: linking

Hi Shaper,

Thank you for your question and welcome to the forum.

I am in the process of finding a method of achieving this without using VBA.

As soon as I have an answer I will email you.

Regards

Simon

Mon 9 Nov 2009, 13:24 Trainer Simon said...

RE: linking

Hi Shaper,

You could copy the data to another sheet and paste into the same cell range as the original data.

Then you could group the two sheets together and then insert or delete sheets. As the sheets are grouped, the rows will be inserted or deleted in both sheets.

Regards

Simon

Mon 16 Nov 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips

Linking

Linking

RE: linking

RE: linking

Excel articles

Excel tip:

Quickly insert a function