Search:

Hello All

I have an Excel template into which I want to import XML. I know how many columns the XML will have, but not how many rows. I have an XML map attached to my template. When I import the...

Hello All

I am interested in embedding Help into Word documents. For example, is it possible to have an option on the Help menu that opens a help file that is document-specific? Or to have F1 help...

Hello All

I am interested in embedding Help into Excel workbooks. For example, is it possible to have an option on the Help menu that opens a help file that is document-specific? Or to have F1...

Thanks, Steve. So simple...
I guess "scatter" wasn't intuitive enough for me.

Roger

This is going to sound really stupid, but here goes:

I am creating a line graph using three sets of numbers.
8.8 171.3 230.3 470.7 578.5 704.7
7 140 298 494 1159 1513
7 112 227 448 1091 1215
I...

I am familiar with using a Styleref field in a header to pick up text from a paragraph of a designated style, e.g. Heading 1. Is it possible to designate a choice of styles? For example, can I create...

Hello All

I have a document that's divided into sections, one section being a protected form. Protecting switches off all kinds of menu options for the whole document. I need to re-enable the...

Hello Hans

Thankyou so much. This works fine, though I had to remove a few odd spaces that crept in during copy and paste.

Roger

Thanks to you, Jan, and Hans too.

Both the answers you gave are good, but is there any way I can combine the formulas so that:

The cell contents on Sheet2 automatically update if columns and...

I have a workbook with two worksheets. On Sheet2 I want to display the values of some cells on Sheet1, so I type the formula =Sheet1!A1. I now expand the formula by dragging into adjacent cells so...