Message:

<p>[QUOTE=&quot;calcol, post: 8443646, member: 77639&quot;]To copy a set composition table from the PCGS registry to your spreadsheet:</p><p><br /></p><p>1.&nbsp; Make sure all the data you want is on the page.&nbsp; Look in the lower left corner to see how many rows of data exist.&nbsp; You can change the number rows per page with the Show option also in the lower left corner.</p><p><br /></p><p>2.&nbsp; Using the mouse, highlight the data.&nbsp; Note you will be highlighting entire rows.&nbsp; No way to avoid this with most browsers.</p><p><br /></p><p>3.&nbsp; Right-click the highlighted area and chose copy from the menu.&nbsp; Alternately, press ctrl-C on the keyboard.&nbsp; This action puts the table in the clipboard.</p><p><br /></p><p>4.&nbsp; Choose an empty area on the spreadsheet that can accommodate all the rows of data plus at least 4 columns of data.&nbsp; Right click on the upper left corner of this area.</p><p><br /></p><p>5.&nbsp;&nbsp; The following may vary a bit for different brands of spreadsheet:</p><p><br /></p><p>&nbsp; From the menu that appears, paste may be an option that you can use (alternately ctrl-V from the keyboard).&nbsp; This will paste the data into the spreadsheet along with the html formatting (and maybe more) used on the webpage.</p><p><br /></p><p>The html formatting (and maybe more) may be undesirable and hard to change.&nbsp; I highly recommend that when you right click on the area in the spreadsheet that if the spreadsheet offers an option to paste the data as plain text, use that option.&nbsp;&nbsp; May appear as paste text, paste options or paste special in the menu.&nbsp; If you bring in the data as plain text, any formatting will be your own, and you won’t bring in undesirable links and other trash.</p><p><br /></p><p>Delete any columns of data, like weights and bonuses, that you don’t want to keep.</p><p><br /></p><p>Cal[/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