Hi Everyone,
I'm putting together a spreadsheet for a work project. Part of it's function is to track the provisions we put in place for our customers.
At the moment, I have three spreadsheets. One has a list of provisions you can pick from a drop down, the second is a weekly feedback sheet and the third is an overall feedback sheet.
My issue is as follows :
On the weekly feedback sheet, I need it to display only the new values per week.
E.g, if 5 people were put on provision a on the 1st of january then 4 more were put on it in week 2, i'd need week 1 to read 5 and week 2 to read 4.
At the moment, because i'm just doing a "countif(a:a, Provision A)" so it is throwing up a 9.
Is this going to be a formula or a macro? My VBA skills are poor at best, and so any pointers would be appreciated re : this issue.
At the moment, I have all the weeks outlined on a seperate format, i've tried doing an array and so at the moment, my only potential solution is to add a row for each and then have a yes no box below, to manually say if anything has changed, however, that would require the person to go in to the file at the start of each week and reset all the values back to no- which isn't going to be possible.!
The second thing I have already tries was to get it to work out the difference between provisions from the previous week and this week, however if there are, say, 3 people taken off of provision a and 1 person put on provision a in a week, it'll show as -2, I need it to show at -1
I hope this made some sense- Apologies for lack of pictures.
Summary :
I have a spreadsheet that allows us to pick up to three provisions per customer.
I need a weekly feedback sheet to say how many people were referred to (for example) provision a in a week.
I have the week start and end dates set out, but have no idea if i can make it select only the changes.
I'm putting together a spreadsheet for a work project. Part of it's function is to track the provisions we put in place for our customers.
At the moment, I have three spreadsheets. One has a list of provisions you can pick from a drop down, the second is a weekly feedback sheet and the third is an overall feedback sheet.
My issue is as follows :
On the weekly feedback sheet, I need it to display only the new values per week.
E.g, if 5 people were put on provision a on the 1st of january then 4 more were put on it in week 2, i'd need week 1 to read 5 and week 2 to read 4.
At the moment, because i'm just doing a "countif(a:a, Provision A)" so it is throwing up a 9.
Is this going to be a formula or a macro? My VBA skills are poor at best, and so any pointers would be appreciated re : this issue.
At the moment, I have all the weeks outlined on a seperate format, i've tried doing an array and so at the moment, my only potential solution is to add a row for each and then have a yes no box below, to manually say if anything has changed, however, that would require the person to go in to the file at the start of each week and reset all the values back to no- which isn't going to be possible.!
The second thing I have already tries was to get it to work out the difference between provisions from the previous week and this week, however if there are, say, 3 people taken off of provision a and 1 person put on provision a in a week, it'll show as -2, I need it to show at -1
I hope this made some sense- Apologies for lack of pictures.
Summary :
I have a spreadsheet that allows us to pick up to three provisions per customer.
I need a weekly feedback sheet to say how many people were referred to (for example) provision a in a week.
I have the week start and end dates set out, but have no idea if i can make it select only the changes.