Quote:
Originally Posted by Jon Stratis
We use a scouting spreadsheet that utilizes macros pretty heavily.
...
Anyways, with the reliance on macros and more advanced excel functions like custom lists, it can be difficult to adapt something like that to a different set of data. If you're comfortable trying, let me know and I can send over one I have for you to work on!
|
I know that I've always had to create a new system every year. You're right, you cant just re-use, but that's part of the challenge. We cant re-use robots, we cant re-use code, we can only carry our knowledge on. Take what you already know from previous years and make something even better.
I risk being rude here so apologies in advance. It seems like you're asking a bit much for a member of the community to do this for you. You wouldn't ask Chief Delphi to program your robot would you?
If you want something easier I suggest using pivot tables. Tableau is pretty simple it would replace that second sheet you mentioned.