This is amazing and as a set collector is quite literally everything I could ask for in a collection tracker. I tried to build something similar to this but failed due to my inexperience and lack of understanding for Excel. The percentage calculator is beautiful and the wishlist is something I never thought I’d want! I’m downloading it now, thank you so much for your hard work!
One suggestion I have is to potentially include a percentage and unique card count tracker for total English cards, total Japanese, and total English + Japanese? Completely unnecessary though, and it would probably take way too much time…but just a thought for you!
I do have two questions though, and they may be easy answers lol. But is there a way for me to update the spreadsheet with new sets as they come out without manually replicating the format you have? Like would I be able to essentially copy/paste the skeleton of a previous set or would I need to learn how to code everything in on my own? And along a similar vein, how would I go about updating the “Additional Cards” section when inevitably more cards are released? Sorry if these questions are kind of tutorial-y, but I really can’t wait to dive into this! Again, you’ve done god’s work!
Hi There, This is music to my ears thanks so much for the kind words it makes it all worth while, and thank you for your suggestions that’s certainly something for a future update,
As for adding new sets this is kind of my sticking point for me to, you could for sure copy and paste the format to add another set with all the information but what you will be missing is that data on the home page, the home page works through the macros and a few changes would have to be made to add the new sets,
I can easily share the sheets with updated information the user would just have to copy and replace certain sheets if that makes sense or I could add it to my copy, release a new copy with updated sets the only problem here is that the user would have to copy and paste all set values over (a small task in comparison to the work I’ve put in haha)
But yeah thanks again and I hope you enjoy using it many thanks
Ah okay, if I can learn how to update the home page on my own, then I should be able to just copy/paste sheets as newer sets release. The heavy lifting you’ve done is phenomenal. I’ve started to go through my sets and fill out the checklists…thank you again for the resource more people should be looking at this!!
My Pleasure, I’m very glad its useful to you and I also agree more people should be looking at this but I guess its not for everyone hopefully with time it will gain traction but at the moment its just spam to some people I don’t actually know why this thread has been moved into this category of inside information but yeah I’ve ran out of places to post this and some groups just wont allow it at all, the hope is that it will be shared by the people that use it and see the effort put in
Hey, I have a question for you all, I’ve been thinking about adding market prices to this workbook and I’ve created a link to a website using a scraping method to get the data but I’m no expert in this field I’m not sure how to go about it or if it’s even possible to have it working for other users, does anyone have any advice? please