Message:

<p>[QUOTE=&quot;Beefer518, post: 2986092, member: 87737&quot;]There are a number of inventory tracking spreadsheets out there, but none had really what I wanted, so I made one for myself. Figured others may find it useful, so I thought I&#039;d share it.</p><p><br /></p><p>This is for Large cents, but it can easily be modified for any series. To quickly do a different series, I go to Numismedia&#039;s site, highlight the full page of the series, copy and paste it to a blank worksheet, then just copy and paste the first column. I&#039;ll then clean it up by deleting the hyperlinks, objects, and any designations (BN/RB/RD as an example) that I don&#039;t need/want. </p><p><br /></p><p>To add a picture of the coin, I put an icon with a local file hyperlink in the pic column. Really simple, once you&#039;ve done it. </p><p><br /></p><p>You&#039;ll need to make some adjustments for other series that have more or less rows then the large cents. </p><p><br /></p><p>The columns are formatted for dates, currency, and general numbers as you would expect, and you can modify it to fit your needs simply.</p><p><br /></p><p>So far I&#039;ve done one for Large Cents, Washington Quarters, Dollars (all), Silver Commems, and Franklins. They each take about 5-10 minutes to add or remove rows. Filling in the individual coin data can be time consuming, but it&#039;s rewarding at the end.</p><p><br /></p><p>Oh, the CDN wholesale I use is for the specific coin in it&#039;s specific grade. So an MS63 coin gets the CDN price for a 63. For those that don&#039;t have access to, or can&#039;t figure out how to get CDN wholesale prices for free, you can use whatever price guide you want.</p><p><br /></p><p>If the enclosed .zip files doesn&#039;t decompress or work correctly, and you&#039;d like me to email you an uncompressed file, just PM me with your request (and email addy).</p><p><br /></p><p>Have fun...[/QUOTE]</p><p><br /></p>

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in