Replies

Steve, I am not familiar with using checkboxes, and Excel Help is no help. Can you explain, or point me someplace with a tutorial?
Also, I noticed in the file you attached Excel told me there were macros in it. What function did the macros play?
Thanks

Thanks to everybody for the direction and ideas!
Just to clarify, the document is one that I created to save time when the sales person makes a proposal to a potential client. Presently, the first two pages of my document is text that I created from which they can pick and choose which paragraphs to use, depending on the client and situation. They delete the parts that do not apply. There are two pricing figures that the sales person puts in these paragraphs that need to be then included in the spreadsheet at the end of the document.The ideal situation (I initially thought) would be bookmarks whose contents then appear in the spreadsheet, except that Hans said above that they would not update automatically.

It seems like the solution is to use Excel with text boxes for parts of the first two pages, with some text in cells for the areas with the numbers that need to be transferred to the spreadsheet. Then have the spreadsheet part with the calculations at the bottom. I’m just afraid it may become a formatting nightmare to create it initially. The problem is that it needs to have a nicely formatted appearance after the sales person deletes the various unwanted parts of the text (which works well in Word, not sure about text boxes). I will try working with the text boxes and see how well it goes.
Thanks again.

Thanks to everybody for the direction and ideas!
Just to clarify, the document is one that I created to save time when the sales person makes a proposal to a potential client. Presently, the first two pages of my document is text that I created from which they can pick and choose which paragraphs to use, depending on the client and situation. They delete the parts that do not apply. There are two pricing figures that the sales person puts in these paragraphs that need to be then included in the spreadsheet at the end of the document.The ideal situation (I initially thought) would be bookmarks whose contents then appear in the spreadsheet, except that Hans said above that they would not update automatically.

It seems like the solution is to use Excel with text boxes for parts of the first two pages, with some text in cells for the areas with the numbers that need to be transferred to the spreadsheet. Then have the spreadsheet part with the calculations at the bottom. I’m just afraid it may become a formatting nightmare to create it initially. The problem is that it needs to have a nicely formatted appearance after the sales person deletes the various unwanted parts of the text (which works well in Word, not sure about text boxes). I will try working with the text boxes and see how well it goes.
Thanks again.

OK here it is

OK here it is

I’m willing to look into doing it that way, but I am not familiar with the text capabilities of Excel. Can I create a text box so I am not putting text in small cells? I have 2 pages of text.

It has 2 pages of text in addition to the spreadsheet, and figures in the text need to be referenced in the spreadsheet.

It has 2 pages of text in addition to the spreadsheet, and figures in the text need to be referenced in the spreadsheet.

Thanks for details. I will play with this a bit, but unfortunately it may not work for my present situation. I need something that would update automatically when the number in the document is changed. I am dealing with sales people who change an item at the top, depending on the client, and then I need for the worksheet below to change automatically. It’s too much to expect these sales people to remember to update the link.

Thanks for details. I will play with this a bit, but unfortunately it may not work for my present situation. I need something that would update automatically when the number in the document is changed. I am dealing with sales people who change an item at the top, depending on the client, and then I need for the worksheet below to change automatically. It’s too much to expect these sales people to remember to update the link.

Maybe I will play around with doing it with the bookmark, even though it is risky. Do you know how to reference a number in a Word bookmark when I am creating a formula in an embedded spreadsheet?

Maybe I will play around with doing it with the bookmark, even though it is risky. Do you know how to reference a number in a Word bookmark when I am creating a formula in an embedded spreadsheet?

What I am wondering is if I embed 2 separate small worksheets in a Word doc, can I reference cells in Worksheet A in formulas that are in Worksheet B?

What I am wondering is if I embed 2 separate small worksheets in a Word doc, can I reference cells in Worksheet A in formulas that are in Worksheet B?

Thanks for the info. If the bookmarks have a tendency to disappear, then the people I am working with will be sure to do that, of course.
But I do need to see if I can make this happen somehow, though. Can I create a single cell spreadsheet and embed it in the paragraph, and then have the number inserted there appear in my worksheet below?