Hi, I'm sure you guys will be able to answer this one for me
I have a spreadsheet with 'Jan-Dec' and a 'Review' tab (13 tabs in total). The sheet is used to keep track of the value (£) of quotes for any given month.
This is what I'd like to happen;
If a job quoted in September was won in October, if the status on that quote is set to 'won' and the relevant 'win' month is also selected, I'd like the figures associated with that quote to be added to a cell on the 'Review' tab in the month that it was won (I hope that makes sense) - please see screen shot of the September tab completed as per my example.
I
I hope this all makes sense and please accept my thanks in advance!!!
I have a spreadsheet with 'Jan-Dec' and a 'Review' tab (13 tabs in total). The sheet is used to keep track of the value (£) of quotes for any given month.
This is what I'd like to happen;
If a job quoted in September was won in October, if the status on that quote is set to 'won' and the relevant 'win' month is also selected, I'd like the figures associated with that quote to be added to a cell on the 'Review' tab in the month that it was won (I hope that makes sense) - please see screen shot of the September tab completed as per my example.
I
I hope this all makes sense and please accept my thanks in advance!!!