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

erol sinan zorlu

Iron Contributor

Nov 21, 2018

can you share the workbook?

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!