Forum Discussion
Create worksheet from data in another worksheet with lots of conditional or if...then ???? HELPT
- Nov 23, 2018
Hello,
Please check the attached file. I have created formulas for "Bob". You can create similar ones for other people.
Erol,
I'm sorry but I'm a little new to this kind of thing in excel. I don't really understand how all that works. So in the second sheet I already have the day, date, plan, etc, referencing the correct cell on the first sheet for each day because that is fairly static. Will what you told me to do start at the top under "Sunday" and look for the first person listed under that day, list their name, unit goal, and dollar goal. Then search again starting after that person and going down until they find the next person working etc until it finds them all? It may not be possible but I'm hopeful. Sorry again for not being more knowledgeable about this.
Thanks again,
Marc
can you share the workbook?
- Marc von OsinskiNov 23, 2018Copper Contributor
I've attached the workbook. The tabs I'm working with are Associate Goals and Daily Goals.
Thanks!
- erol sinan zorluNov 23, 2018Iron Contributor
Hello,
Please check the attached file. I have created formulas for "Bob". You can create similar ones for other people.
- Marc von OsinskiNov 23, 2018Copper Contributor
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!