Forum Discussion
I would like to Sum all numbers in a word document which are currencies or bigger than 100.
The thing is that im trying to make a document for my work. We are sending out a lot of different offers for people to stay in our hotel. Our document has a lot of variables. Like number of adults, children, normal room, or suite.. etc.. so a lot :D.
I would like to have a document, that can count the total price if I add the details in ( like number or person, how many nights, etc) - this one can be done by bookmarks and stuff. But the problem is, that if its a normal room, it will work, but if its a suite, I have to add a new line to the document, which is the extra price for it, and of course the field wont add that into the total price, since its a new line, and its not bookmarked.
Is there any way I can write a formula or something, so that it will recognize the newly added number and count it in.
Thank you in Advance!
arthas1225 I would create a UserForm into which you insert the details and upon completion have the data transferred to a Word document.
See the following pages of Greg Maxey's website :
2 Replies
arthas1225 I would create a UserForm into which you insert the details and upon completion have the data transferred to a Word document.
See the following pages of Greg Maxey's website :
- Thank you for your asnwer!
Its a little complicated for me, but I will try to make this work.
So if I want it to calculate a total price, I can just add the different price details into the UserForm, and then in the template, i just make a formula referencing the form details, right?
