Updated January 24, 2011 with notes about v4!
Sorry this has taken so long! I updated the spreadsheet with several improvements:
+ Expanded designer list, including when designers create something as part of a CD
+ Improved formulas to take into account now 5 digit store numbers (10,000 and greater)
+ Hopefully true copy + paste from the store for new and previous orders!
I have to say, I had a bit of a recent shopping spree, and it was so nice and easy just to copy and paste everything!
The first post has been updated with the new spreadsheet. You can download it: DSP Links to Share v4.zip
(280.9 KB, 0 views)
You can copy and paste information from a store purchase either right at time of purchase, or from your Order History. For a new Order, you want to copy and paste right from the download section of your order, and if you want to populate your history or purchases, go to My Account > Show All Orders > View Button on each order. See below for more details.
Here are a few screen shots that should illustrate how to populate the spreadsheet:
Step 1 (updated for v4!)
First, from the download section of the store, select all your rows of data, plus the end part of the row descriptions - "Keyword*" like this:
Right click > copy:
Step 2 (follow A or B depending on if your order is new or not)
Option A: For a New Order (with Active Download Links)
Next, with the spreadsheet open in Excel, go to the DSP Kits tab. Place your cursor in the first empty blue cell. Right click and select Paste Special.
Option B: For an Old Order (no active download links)
Next, with the spreadsheet open in Excel, go to the DSP Kits tab. Place your cursor in the first empty purple cell. Right click and select Paste Special.
Select Text from from the pop-up box, and click OK.
This should be what happens after you pasted. The columns on the left side automatically parse information out of the store information. The yellow highlighted column is the column you copy and paste from to post a "pretty" link on DSP.
If you already have one of my earlier spreadsheets started, I would suggest copying and pasting from the old version into the new version. Here is step by step instructions and screen shots.
First, open both spreadsheets, the one you have your data in, and the new spreadsheet.
In you OLD spreadsheet, select the data in columns A, B, C and D, and then right click > Copy:
Go to the new spreadsheet, and put your mouse in the first blank cell in column A under the headers (there will be a 0 and formulas in the cell, I mean blank of any data), right click > Paste Special:
Click the radio button for Values and click OK:
This should leave the data like:
If you are having troubles at all, post here, or send me a PM. You can always send me your spreadsheet (via email) and we can work through it!