5/23/18 EDIT - if you find yourself more confused by this video, but still want to utilize the concept, I've uploaded the file i use in the video for you guys to use and customize! Have fun
In this video, I show you how you can use Excel's commands to generate a database to sort your cards and also automatically generate a URL to get the price! (as opposed to looking it up manually). I've managed to streamline the entire process and made everything sans entering data automatic! Hopefully this can serve as some help!
•Card Name / Pack Name condensed (Change A2 to reflect the cell that the card name / pack name is in):
=IF(ISNUMBER(SEARCH(" ",A2))=TRUE,SUBSTITUTE(removeSpecial(A2)," ","-"),A2)
•URL Generator (Where H2 and G2 are the pack name condensed and card name condensed respectively
•Special Command (Hit ALT + F11, then "Insert" then select Module):
Function removeSpecial(sInput As String) As String
Dim sSpecialChars As String
Dim i As Long
sSpecialChars = ".,:'"
For i = 1 To Len(sSpecialChars)
sInput = Replace$(sInput, Mid$(sSpecialChars, i, 1), "")
removeSpecial = sInput
Excel file: https://drive.google.com/open?id=1iGVyZ5CxHVxcmYwa_iQ95HejIWNp_Rlu
SUBSCRIBE TODAY! http://bit.ly/SubToSaturn
Also, be sure to hit that Like button!!
Follow me on Twitter to keep up to date on things!
If you like my videos and such, you can watch me play video games live on Twitch, be sure to follow me there to know when I go live!
Outro Song: "Black and White Relic Castle Remix v.II" - GlitchxCity
Link to song: http://bit.ly/SaturnOutro
Hopefully you like my content enough to hit the subscribe button to hang around and watch some more of my content, it is appreciated but of course not required, have a good day!