Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tracking New Tabs in Excel
Hello,
I am trying to set up a way to track information in a "tracking tab" for new tabs that I add for quotes on new business. So, we have a basic template that we copy 2-3 times a day to develop new quotes. I want to extract key info from each quote in this tracking tab (date of quote, customer, $ amount, etc.). The problem I have is that each time I add a new tab I need to manually copy my formula down one line in the tracking tab and edit the formulas to link to the new tab. Is there a way to set up the formulas in the tracking tab so that when we add a new tab for a quote the summary information will automatically populate a new line in the tracking tab. Any help is much appreciated. Regards, John M |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tracking New Tabs in Excel
Sounds a job for the Template Wizard with Data Tracking.
You create a Template workbook for your quotes. Each new quote information is added to a database workbook. The new quote is saved as its own workbook. It is difficult to obtain the Wizard on-line but if you email me I can send you a copy. Was designed for earlier version of Excel but I have suceesfully used it in Excel 2003 and 2007. My email is gorddibbATshawDOTca change the obvious. Gord Dibben MS Excel MVP On Wed, 31 Mar 2010 07:24:02 -0700, John M wrote: Hello, I am trying to set up a way to track information in a "tracking tab" for new tabs that I add for quotes on new business. So, we have a basic template that we copy 2-3 times a day to develop new quotes. I want to extract key info from each quote in this tracking tab (date of quote, customer, $ amount, etc.). The problem I have is that each time I add a new tab I need to manually copy my formula down one line in the tracking tab and edit the formulas to link to the new tab. Is there a way to set up the formulas in the tracking tab so that when we add a new tab for a quote the summary information will automatically populate a new line in the tracking tab. Any help is much appreciated. Regards, John M |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Tracking Changes | Excel Worksheet Functions | |||
Tracking Changes in Excel | Excel Discussion (Misc queries) | |||
Tracking changes in excel | Excel Discussion (Misc queries) | |||
tracking changes in excel | Excel Discussion (Misc queries) | |||
How to insert tracking numbers into my webpage for RMA tracking | Excel Discussion (Misc queries) |