Bernhard99
New Member
- Joined
- Apr 2, 2013
- Messages
- 1
Hi! I am an accountant at a small consulting company and I am responsible for a shared excel model where our managers enter the different projects that generate income for our company. It is about 250 rows and 12 columns (Jan-dec).
Now I want to be able to classify the figures each month per project into what is 1) safe 2) probable 3)pure “sales budget”.
I could of course make three different sections of the excel sheet for this.
But I don’t want our managers to cut and paste and move too much data much in the excel sheet as projects move from being 3) to 2) to 1).
I wonder if there is an alternative?
Can I use another coding system for defining what is 1) 2) or 3)?
Eg can I for one project/row for Jan-Dec ask them to use color or other coding for the figures to state that Jan-March is 1) and April-Aug is 2) and Sep-Dec is 3) and then be able to sum “all figures for all projects that are coded as 1) in column H, ie February”
I very much appreciate if someone would point me in the right direction. My excel skills are getting a bit rusty J Im sorry if this is a basic or repetetive question.
We run MS Office 2010 and Excel 2010 on PC.
Now I want to be able to classify the figures each month per project into what is 1) safe 2) probable 3)pure “sales budget”.
I could of course make three different sections of the excel sheet for this.
But I don’t want our managers to cut and paste and move too much data much in the excel sheet as projects move from being 3) to 2) to 1).
I wonder if there is an alternative?
Can I use another coding system for defining what is 1) 2) or 3)?
Eg can I for one project/row for Jan-Dec ask them to use color or other coding for the figures to state that Jan-March is 1) and April-Aug is 2) and Sep-Dec is 3) and then be able to sum “all figures for all projects that are coded as 1) in column H, ie February”
I very much appreciate if someone would point me in the right direction. My excel skills are getting a bit rusty J Im sorry if this is a basic or repetetive question.
We run MS Office 2010 and Excel 2010 on PC.
