Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Using formulas in tables
I want to use an invoice template but I am having a very hard time figuring
out the formulas to use to calculate taxes etc. Can I change my view to reference a cell in word so I can see what column & row to enter into my formula? |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Using formulas in tables
See the following page of fellow MVP Greg Maxey's website:
http://gregmaxey.mvps.org/Table_Cell_Data.htm You may also want to take a look at fellow MVP Macropod's tutorial on formula field coding at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Shayla2008" wrote in message ... I want to use an invoice template but I am having a very hard time figuring out the formulas to use to calculate taxes etc. Can I change my view to reference a cell in word so I can see what column & row to enter into my formula? |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Using formulas in tables
How do I get the Table Cell Data Add In so I can reference cells in the
table. It is not in my list of add ons in my word options. I couldn't locate it on microsoft either... Thanks, Shay "Doug Robbins - Word MVP" wrote: See the following page of fellow MVP Greg Maxey's website: http://gregmaxey.mvps.org/Table_Cell_Data.htm You may also want to take a look at fellow MVP Macropod's tutorial on formula field coding at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Shayla2008" wrote in message ... I want to use an invoice template but I am having a very hard time figuring out the formulas to use to calculate taxes etc. Can I change my view to reference a cell in word so I can see what column & row to enter into my formula? |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Using formulas in tables
You need to read the web page to which I directed you.
The instructions for how to use Greg's method are included near the bottom of his webpage Quote To use TableCellData, simply copy the macro and two functions to a module in your VBA project. For help with this, see fellow MVP Graham Mayor's Guide for Installing Macros. To assign TableCellData to a keyboard shortcut see How to assign a Word command or macro to a hot-key. To assign to a menu (including mouse right button shortcut menu) or toolbar button, see How to assign a Word command or macro to a toolbar or menu. Unquote If you want to use the less capable Microsoft macro, click on the Macros8.Dot link in the first paragraph of Greg's webpage and then on the page that you are taken to, you will find a "following this link" link about a quarter to a third the way down the page. Both of these web pages contain instructions, or links to instructions that tell you how to make use of whichever utility that you do download. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Shayla2008" wrote in message ... How do I get the Table Cell Data Add In so I can reference cells in the table. It is not in my list of add ons in my word options. I couldn't locate it on microsoft either... Thanks, Shay "Doug Robbins - Word MVP" wrote: See the following page of fellow MVP Greg Maxey's website: http://gregmaxey.mvps.org/Table_Cell_Data.htm You may also want to take a look at fellow MVP Macropod's tutorial on formula field coding at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Shayla2008" wrote in message ... I want to use an invoice template but I am having a very hard time figuring out the formulas to use to calculate taxes etc. Can I change my view to reference a cell in word so I can see what column & row to enter into my formula? |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
Using formulas in tables
I did and hoped there would be an easier way like just finding an add in and
clicking on it...hopes dashed. I have never worked with macros before. I followed all the instructions and I do not have the Table Cell Data added to my ribbon. When I manually try to run the macro the error message comes up and says Compile error: Amibiguous name detected: TableCellData and is highlighting the very first line of the macro Sub TableCellData () What do I do with this? I copied the macro and two functions at once. Do I need to copy and paste the functions elsewhere? Thanks, Shay "Doug Robbins - Word MVP" wrote: You need to read the web page to which I directed you. The instructions for how to use Greg's method are included near the bottom of his webpage Quote To use TableCellData, simply copy the macro and two functions to a module in your VBA project. For help with this, see fellow MVP Graham Mayor's Guide for Installing Macros. To assign TableCellData to a keyboard shortcut see How to assign a Word command or macro to a hot-key. To assign to a menu (including mouse right button shortcut menu) or toolbar button, see How to assign a Word command or macro to a toolbar or menu. Unquote If you want to use the less capable Microsoft macro, click on the Macros8.Dot link in the first paragraph of Greg's webpage and then on the page that you are taken to, you will find a "following this link" link about a quarter to a third the way down the page. Both of these web pages contain instructions, or links to instructions that tell you how to make use of whichever utility that you do download. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Shayla2008" wrote in message ... How do I get the Table Cell Data Add In so I can reference cells in the table. It is not in my list of add ons in my word options. I couldn't locate it on microsoft either... Thanks, Shay "Doug Robbins - Word MVP" wrote: See the following page of fellow MVP Greg Maxey's website: http://gregmaxey.mvps.org/Table_Cell_Data.htm You may also want to take a look at fellow MVP Macropod's tutorial on formula field coding at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Shayla2008" wrote in message ... I want to use an invoice template but I am having a very hard time figuring out the formulas to use to calculate taxes etc. Can I change my view to reference a cell in word so I can see what column & row to enter into my formula? |
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
Using formulas in tables
It sounds like you might have copied the Sub TableCellData() macro more than
once. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Shayla2008" wrote in message ... I did and hoped there would be an easier way like just finding an add in and clicking on it...hopes dashed. I have never worked with macros before. I followed all the instructions and I do not have the Table Cell Data added to my ribbon. When I manually try to run the macro the error message comes up and says Compile error: Amibiguous name detected: TableCellData and is highlighting the very first line of the macro Sub TableCellData () What do I do with this? I copied the macro and two functions at once. Do I need to copy and paste the functions elsewhere? Thanks, Shay "Doug Robbins - Word MVP" wrote: You need to read the web page to which I directed you. The instructions for how to use Greg's method are included near the bottom of his webpage Quote To use TableCellData, simply copy the macro and two functions to a module in your VBA project. For help with this, see fellow MVP Graham Mayor's Guide for Installing Macros. To assign TableCellData to a keyboard shortcut see How to assign a Word command or macro to a hot-key. To assign to a menu (including mouse right button shortcut menu) or toolbar button, see How to assign a Word command or macro to a toolbar or menu. Unquote If you want to use the less capable Microsoft macro, click on the Macros8.Dot link in the first paragraph of Greg's webpage and then on the page that you are taken to, you will find a "following this link" link about a quarter to a third the way down the page. Both of these web pages contain instructions, or links to instructions that tell you how to make use of whichever utility that you do download. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Shayla2008" wrote in message ... How do I get the Table Cell Data Add In so I can reference cells in the table. It is not in my list of add ons in my word options. I couldn't locate it on microsoft either... Thanks, Shay "Doug Robbins - Word MVP" wrote: See the following page of fellow MVP Greg Maxey's website: http://gregmaxey.mvps.org/Table_Cell_Data.htm You may also want to take a look at fellow MVP Macropod's tutorial on formula field coding at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Shayla2008" wrote in message ... I want to use an invoice template but I am having a very hard time figuring out the formulas to use to calculate taxes etc. Can I change my view to reference a cell in word so I can see what column & row to enter into my formula? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying Understand Formulas In Tables | Tables | |||
Formulas in Tables | Tables | |||
Tables and Formulas in Forms | Tables | |||
FORMULAS IN TABLES | New Users | |||
Tables/Formulas | Tables |