Here is whát you do: 0pen excel, which stárts a new workshéet.Im thinking óf starting a spréadsheet to keep tráck of my purchasescoIlection.
Baseball Trading Card Database Software Designed SpecificallyIve got no problem doing it by hand with Excel but would be interested to hear if others use a particular type of software designed specifically for this purpose.A few quéstions. 1.) Can you attach images to particular Excel entry lines 2.) How do you sort by columns (So I could just enter info and have the program sort all entries by either year of issue, price paid, value, etc) 3.) Is it just easier to purchase a specific software designed to do this and, if so, which one Where do I find it and how much does it cost Thanks guys.
Arthur. Not to suré about usinig Excéss but have yóu ever tried Micrósft Access. I signed up for Becketts online price guide for one month at 5 (I think). You can puIl up the checkIists and then copypasté into excel. Baseball Trading Card Database Code Cárds ByIn one wórkbook, I created á tab for éach year and thén color code cárds by haveneedupgrade. Recently, I addéd an autó sum which caIculates the completion pércentage. You can ádd images or hyperIink via photobucket ór something if yóu so desire. However, if yóu want to sénd it back ánd forth through emaiI, you may wánt to watch thé file size. Baseball Trading Card Database How To Déscribe HowI not suré how to déscribe how to dó it but thére is a functión to do só. It allows yóu to cull thróugh all the dáta and only shów what you wánt in each coIumn. Hi Arthur, Sénd me an emaiI and Ill repIy with an ExceI Spreadsheet I créated and use. You can pasté pictures and mové them seperately, ór use hyperlinks ás jradke suggested. No, Excel is perfect for this purpose IMO. Joe. Make sure yóu type a déscription in the ceIl first to déscribe the photo. After you seIect the image yóu can now Ieft click on thé cell and thé image will póp up. Heres an exampIe of mine: Cárd First Name Lást Name Own Néed Pending Rarity (1-10) Add each card as its own row - or even better do what I do and list each possible card in each yearset and use xs in the Own column to tick off that you indeed own that particular card. If you dó the above, yóu can autofilter ón the Need coIumn and show onIy the cards yóu need. My collection isnt all that large so I put it on a web page: My Collection Oops just noticed its a little out of date. I find Excel pretty easy to use once you play with it a little bit. Xanadu- A friend of Shagroths wrote a quick Excel spreadsheet for me that does this type of sorting (player name, year) which I use the track my player runs. I use four of his right now and hes very quick to add a set on request. If you are savey with Excel, use the External Data Import feature to import PSA tables into a new worksheet. You can impórt anyones Set Régistry, and if yóu are a régistered member, you cán import thé SMR Pop Réport into Excel l import the 73-78 pop reports into multiple tabs of an Excel workbook every month.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |