Message:

<p>[QUOTE=&quot;geekpryde, post: 2058722, member: 36248&quot;]If you always wanted to create a PCGS want-list, but felt that it would be a very tedious undertaking, I want to share with you a method that could make it a lot easier.</p><p><br /></p><p>Sign in, and find your want-list here.&nbsp;&nbsp; It may already contain some items, or be totally blank like mine was.</p><p><br /></p><p><a href="http://www.pcgs.com/setregistry/mysetregistry/mywanteditems.aspx" target="_blank" class="externalLink ProxyLink" data-proxy-href="http://www.pcgs.com/setregistry/mysetregistry/mywanteditems.aspx" rel="nofollow">http://www.pcgs.com/setregistry/mysetregistry/mywanteditems.aspx</a></p><p><br /></p><p>The fastest way I&#039;ve found to create a want-list is to use the <b>upload </b>feature at PCGS and simply bring in your want list.&nbsp; The only column you really need is the <b>PCGSNo </b>field.</p><p><br /></p><p>You don&#039;t need to use Excel, any spreadsheet type program that is easy to use and can save your file as a comma-separated values file type will work.&nbsp; You could even use notepad!</p><p><br /></p><p>Here is what my Excel file looks like:</p><p><br /></p><p>[ATTACH=full]379330[/ATTACH]</p><p><br /></p><p>Header-row names must be named exactly as above, but can be in any order, and not all require data.</p><p><br /></p><p>I look up the <b>PCGSno</b> values here:</p><p><a href="http://www.pcgs.com/pcgsnolookup/" target="_blank" class="externalLink ProxyLink" data-proxy-href="http://www.pcgs.com/pcgsnolookup/" rel="nofollow">http://www.pcgs.com/pcgsnolookup/</a></p><p>and cut and paste them into my Excel form in bulk.&nbsp;&nbsp; Meaning, you can grab one, or ten, of 50 records all at once.</p><p><br /></p><p>Highlight the coins you want, and hit [CTRL]-C (or right-click COPY).</p><p><br /></p><p>[ATTACH=full]379335[/ATTACH]</p><p><br /></p><p>Then back to Excel to past them in, [CTRL]-V.&nbsp; Don&#039;t worry about the color / font formatting.</p><p><br /></p><p>[ATTACH=full]379336[/ATTACH] </p><p>Do a save-as to create a CSV version, and upload it here:</p><p><br /></p><p><a href="http://www.pcgs.com/SetRegistry/MySetRegistry/AddWantedItems.aspx" target="_blank" class="externalLink ProxyLink" data-proxy-href="http://www.pcgs.com/SetRegistry/MySetRegistry/AddWantedItems.aspx" rel="nofollow">http://www.pcgs.com/SetRegistry/MySetRegistry/AddWantedItems.aspx</a></p><p><br /></p><p>Then you will see something like this:</p><p><br /></p><p>[ATTACH=full]379329[/ATTACH]</p><p><br /></p><p>I have a lot more coins to add, but these 64 will be a good test.&nbsp;&nbsp; See, I went from nothing in my PCGS want list to this in a few minutes work:</p><p><br /></p><p>[ATTACH=full]379331[/ATTACH]</p><p><br /></p><p>Hope this helps![/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