AdamBurgess7
New Member
- Joined
- Jan 24, 2018
- Messages
- 1
Hi folks!
So I have a workbook where I need certain data to copy into a relevant worksheet based on a scoring system I've set up.
The scoring system breaks down as follows and the names of the worksheets are Core, Invest, Opportunistic & Challenge.
The name of the account sits (account name) in cell A3 of worksheet titled Growth Assessment and the score (account score) sits in H3 of the same sheet. Depending on the score, I then need to see a COPY (not a replacement) of the account name and the account score into the appropriate worksheet. This will show in B2 & B3 of the respective worksheet. Any new accounts added to Growth Assessment will be added in the next available row (manually), follow these rules and populate the next available row in the respective worksheet.
If score is 9 or 10 then account sits in Core
If score is 6, 7 or 8 then account sits in Invest
If score is 3, 4 or 5 then account sits in Opportunistic
If score is 0, 1 or 2 then account sits in Challenge
Please let me know if you've any questions. I'm limited on my excel knowledge but have managed to do the data validation and vlookups to get the scores related to a Y or N answer!
Thank you!
So I have a workbook where I need certain data to copy into a relevant worksheet based on a scoring system I've set up.
The scoring system breaks down as follows and the names of the worksheets are Core, Invest, Opportunistic & Challenge.
The name of the account sits (account name) in cell A3 of worksheet titled Growth Assessment and the score (account score) sits in H3 of the same sheet. Depending on the score, I then need to see a COPY (not a replacement) of the account name and the account score into the appropriate worksheet. This will show in B2 & B3 of the respective worksheet. Any new accounts added to Growth Assessment will be added in the next available row (manually), follow these rules and populate the next available row in the respective worksheet.
If score is 9 or 10 then account sits in Core
If score is 6, 7 or 8 then account sits in Invest
If score is 3, 4 or 5 then account sits in Opportunistic
If score is 0, 1 or 2 then account sits in Challenge
Please let me know if you've any questions. I'm limited on my excel knowledge but have managed to do the data validation and vlookups to get the scores related to a Y or N answer!
Thank you!
