I have a basic validation in a cell accepted /declined, if accepted is the selection i need a cell on another sheet to add 1 and derive new total. Now to complicate things for me further i only want that particular cell to have plus 1 if the month is the same as the date on the original sheet that the validation.
So to sum up as i confused myself
say for example a persons data was entered on the 3/6/15 and his application was accepted, on the june row of the second sheet the total of accepted applications would Plus 1 with a new total shown in the cell. Basically the first sheet will be a ongoing livelog with various validations linking to a second sheet which will sum up in relevant columns totals.
think i confused myself if anyone can decipher what i think I'm trying to say will appreciate it, have designed two spreadsheets that i want to link together with formulas to limit work duplication cheers.
Bookmarks