Search results

In case you don't get alerts, PM sent.

Oh dear... "SMP88 has exceeded their stored private messages quota and cannot accept further messages until they clear some space." Oh dear oh dear oh dear...!

Finally after much faffing around I've managed to semi-automate the filling out of the Totals/By Type sheet, and by extension any other Totals sheet, by way of a formula generator. Excel doesn't let me use the value of one cell as an external reference from another cell, so you have to...

Only minor additions to be honest. I've brought Totals up to date apart from the By Type sections, I stopped as I was trying to figure out a way to speed up the process a little, but may just have to slog it. I'll admit I don't use those pages at all myself so haven't felt compelled to do it up...

Hey SMP and all - I've been keeping these up to date on my own computer, including the Remaining Cards and Totals pages, along with an improvement here and there since I've gotten a little more familiar with Excel. I wouldn't want to steal your thunder on these wonderful lists, but to save you...

Aww yeah promo lists! Nice one dude - yoink

You rock dude, meticulous is the word!

Nice one dude - missed this by like a week, just checkin them and they look great. Personally I think setting the same width might look a little silly on account of those HGSS double-named legend cards, or others pushing the column width out. I reckon they are fine as is, but I don't really mind...

Looks good man, I gave it a whirl and its fine on my PC for the Jungle list. Yeah you're solution is a lot tidier than my example formula I gave with 6 nested IFs lol. It works on my phone as well almost perfect, though I think the little issues I do get with it are due to the app (Polaris or...

Thanks for the update - sounds good, only two tiny little things I've spotted otherwise is the title for "Nobel Victories", it's meant to be "Noble Victories", but not an issue if its a pain to change as you've rigged it into the Totals I expect. Second is the totals page column widths aren't...

I'm pretty sure its standard - but even if not, after making that formula and changing the font of the cells afterwards, the symbols seem to be in most fonts - normal Arial displays them all fine as well, with the letters next to them. For some reason I found them in one font, but they work in...

Thanks for the update dude! I tried having a go myself at helping make these checklists a lot easier to generate, like with your conditional formatting so far -to make a "template" of sorts, would future-proof your work and keep these the preferred checklists by the community I think! I...

Whoops didn't even check the gallery! That definitely looks like my card, I have no idea how I got it... No stamps or anything but I guess they didn't do that back then... I didnt collect from 2001 - 2009, so :confused: Different folder it goes in then!

Hey man - I have that metal energy card, that's how I know! You've got me thinking its a fake or something now, but it looks fine on inspection. I took a pic for you but can't attach it. It's not a rev holo, those are solid shiny all over, this is the cosmos shiny. Copyright is 2003, so it's the...

Yo SMP88, just spotted that Metal energy 94/109 in the EX Ruby Sapphire set is rare-holo, table says just rare, FYI :) The same may be true for Miracle energy 95/109 but I don't own it so can't confirm. Darkness energy 93/109 is standard rare as table says. One little question, I've been...

Hi SMP88 (and all, first post!) I registered merely to say THANKYOU for this! I've been trying to motivate myself to make these for years; nowhere could I find a complete, up-to-date set list with useful information, in excel, easy to use. Finally! And you've made it all available for the...