thedeadzeds
New member
- Joined
- Oct 25, 2011
- Messages
- 37
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Hi All,
Not sure if this is at all possible but if anyone can figure it out you can...
I have a very basic spreadsheet which consists of 2 worksheets, a main sheet that is completed by staff, and then a summary sheet.
The main sheet shows the following:
a list of staff names in one column - next to each staff is a list of cases. Each staff member requires a Full Audit of one in ten cases. So the main spreadsheet shows 'Full audit' which is then followed by 9 sense checks. Once 9 ten sense checks have been done, another 1 full audit is required and then we can release another 9 sense checks.
The senses available sheet shows the following:
A summary of each staff member and how many sense checks are available before it hits 9 and then another full audit is required.
The senses available sheet is currently manually updated but I wonder if this can be automated. I have attached a copy of the spreadsheet. The senses available sheet currently shows the correct number of sense available which has manually been updated.
Hope this makes sense.
Thanks in advance
Craig
Not sure if this is at all possible but if anyone can figure it out you can...
I have a very basic spreadsheet which consists of 2 worksheets, a main sheet that is completed by staff, and then a summary sheet.
The main sheet shows the following:
a list of staff names in one column - next to each staff is a list of cases. Each staff member requires a Full Audit of one in ten cases. So the main spreadsheet shows 'Full audit' which is then followed by 9 sense checks. Once 9 ten sense checks have been done, another 1 full audit is required and then we can release another 9 sense checks.
The senses available sheet shows the following:
A summary of each staff member and how many sense checks are available before it hits 9 and then another full audit is required.
The senses available sheet is currently manually updated but I wonder if this can be automated. I have attached a copy of the spreadsheet. The senses available sheet currently shows the correct number of sense available which has manually been updated.
Hope this makes sense.
Thanks in advance
Craig