![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Decided to enhance my ASCEM masterlist Excel VBA scripts a little. They are not really nicely programmed, but the new scripts do the following:
- Copy the masterlist.
- Throw away incomplete stories.
- Make an All_Authors list.
- Copy the edited masterlist into a new sheet for each series (TOS, TNG...) and delete all stories that don't belong to that series (crossovers are kept).
- Extract the authors of each series sheet into a new sheet for an authors' list per series.
It was a bit hard, mostly because I only code VBA once a year - whenever I feel my ASCEM/GO lists could use some new features. In my first year, I tried to code categorization scripting, but it never worked satisfactorily (sorry, Cait).
Other than that, have been swimming today (almost no other people, cool) but didn't do anything for my customer - tomorrow, I swear!
- Copy the masterlist.
- Throw away incomplete stories.
- Make an All_Authors list.
- Copy the edited masterlist into a new sheet for each series (TOS, TNG...) and delete all stories that don't belong to that series (crossovers are kept).
- Extract the authors of each series sheet into a new sheet for an authors' list per series.
It was a bit hard, mostly because I only code VBA once a year - whenever I feel my ASCEM/GO lists could use some new features. In my first year, I tried to code categorization scripting, but it never worked satisfactorily (sorry, Cait).
Other than that, have been swimming today (almost no other people, cool) but didn't do anything for my customer - tomorrow, I swear!
