Forum Discussion

Copper Contributor

Oct 25, 2018

Solved

Create worksheet from data in another worksheet with lots of conditional or if...then ???? HELPT

Weekly I have to manually create a worksheet from data in another worksheet and there has to be a way to do it, I just don't know how? Working from a schedule sheet that creates goals for the people...

excel

Formulas and Functions

office 365

erol sinan zorlu
Nov 23, 2018
Hello,

Please check the attached file. I have created formulas for "Bob". You can create similar ones for other people.
8_26_2018Sch.xlsx197 KB

Marc von Osinski

Copper Contributor

Nov 23, 2018

I've attached the workbook. The tabs I'm working with are Associate Goals and Daily Goals.

Thanks!

8_26_2018Sch.xlsx197 KB

erol sinan zorlu

Iron Contributor

Nov 23, 2018

Hello,

Please check the attached file. I have created formulas for "Bob". You can create similar ones for other people.

8_26_2018Sch.xlsx197 KB

Marc von Osinski
Copper Contributor
Nov 23, 2018
Thanks so much! It'll probably take me a little bit to study and make sure I understand it. Once I do I'll let you know how it goes! THANKS AGAIN!
- Marc von Osinski
  Copper Contributor
  Nov 24, 2018
  It took some time but I think now I'm getting it! Thanks so much, this will save me so much time. Why did you use "ROUNDUP?" When I changed the formula for Mack it returned 7 not 6 which is what his goal is for the day?
  
  Thanks!
  - erol sinan zorlu
    Iron Contributor
    Nov 24, 2018
    Well for the number of U's and C's I thought this number was being used. The formula for Bob returned 2,5 and I used roundup to find the closest higher integer. than used formula to generate exact number of U's and C's in below table.