ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Quarterly Leads Tracking Template (https://www.excelbanter.com/excel-discussion-misc-queries/198372-quarterly-leads-tracking-template.html)

Innovman 2006

Quarterly Leads Tracking Template
 
Hi there, I have just downloaded this template and being a newbie, I do not
know how to extend this forecast to a 2 year forecast which is what I would
need? Example how do you change Q1 for instance to read 2008Q1 or conversely
to extend it to 2009Q1 or Q5? Same questions apply to the forecast chart..
period to be extended to 2 or 3 years?? I have been informed that this
template may be locked (cells of values) but how do i unlock the ranges,
cells, values etc. to make the changes as described above? thanks in advance,

S


Innovman 2006

Quarterly Leads Tracking Template
 
OOPs I forgot to mention that I am using Microsoft Excel 2003 Version
11.8211.8202 SP3

"Innovman 2006" wrote:

Hi there, I have just downloaded this template and being a newbie, I do not
know how to extend this forecast to a 2 year forecast which is what I would
need? Example how do you change Q1 for instance to read 2008Q1 or conversely
to extend it to 2009Q1 or Q5? Same questions apply to the forecast chart..
period to be extended to 2 or 3 years?? I have been informed that this
template may be locked (cells of values) but how do i unlock the ranges,
cells, values etc. to make the changes as described above? thanks in advance,

S



All times are GMT +1. The time now is 08:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com