Sheets(2).Range("A1", Cells(lRow, lCol)).Copy Sheets(1).Range("A" & newRow) ' Copy "Foil" rows to original ("Regular") worksheet ' Get row number for inserting new rows from "Foil" worksheet ' delete header row on copied ("Foil") worksheet ' delete Regular count from Foil worksheet ' delete Foil count from Regular worksheet Range("E2", Cells(lRow, 5)).Value = "English" Range("D2", Cells(lRow, 4)).Value = "Near Mint" LCol = Cells(1, Columns.Count).End(xlToLeft).Column LRow = Cells(Rows.Count, 1).End(xlUp).Row 'Find the last non-blank cell in column A(1) SearchFormat:=False, ReplaceFormat:=FalseĬells.Replace what:=fndB, Replacement:=rplcB, _ LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, _ ' remove extra text from card name (e.g., "Golgari Guildgate (a)" or "(b)")Ĭells.Replace what:=fndA, Replacement:=rplcA, _ Masterpiece Series: Amonkhet Invocations > Amonkhet Invocations Time Spiral ""Timeshifted"" > Time Spiral "Timeshifted" (WHY do they have double quotation marks?) Planechase 2012 Edition > Planechase 2012 Magic: The Gathering-Conspiracy > Conspiracy Magic: The Gathering-Commander > Commander List of Mismatched Editions (in this inventory)ĭuel Decks: Kiora vs. Since you just saved it in the previous steps, go ahead and click "Don't Save". When you try to close the file in Excel, it'll ask you to save the changes. Re-import (you don't even have to click "Browse" again on Deckbox just click the "Check file and import" button on the already-selected CSV).Īssuming you caught all the edition name errors, you should be golden! Otherwise, repeat steps 12-15 until you get it right. Then press Ctrl+S (or click the save icon) and click "Yes" at the warning Use Ctrl+H to Replace All for each affected edition. You'll find the Deckbox equivalent on the "Editions" page. (I've provided a list below that I encountered in this specific inventory.) Make note of the incorrect edition names. I say attempt, because you're going to get a long list of errors due to non-matching edition names. TIP: To quickly jump to the end of your regular cards, press Ctrl+A (Select All), which jumps the view down to the final row.Īttempt a first upload. TIP: To easily select all the correct data, delete row 1 on the copied sheet (the header row), then press Ctrl+A. Don't worry about all the rows with a count of 0 - they won't matter. Now select all the entries in the copied sheet (your foils) and copy it to the end of the data in the original sheet. TIP: If you have all the cells selected, press F2 to enable entry in the active cell, type "foil", then press Ctrl+Enter. Important: On the copied sheet (your foils), fill the entire "Foil" column with "foil". Now you should only have one "Count" column on each sheet. In the copied sheet, delete column A (Reg Qty). In the original sheet, delete column B (used to be Foil Qty). Right-click the sheet's tab, choose "Move or Copy.", and check the checkbox for "Create a copy". See step 9 for a tip on quickly filling an entire column. If you don't do this, Deckbox will display them without a condition or language, rather than applying your defaults. TIP: You most likely will also want to insert 2 more columns, named "Condition" and "Language", and fill the entire Condition column with "Near Mint" or "Good (Lightly Played)", and the Language column with "English". Important: Insert a new column (I usually prefer it after the "Name" column, but it actually doesn't matter), and type "Foil" as the header. (Yes, both columns A and B should be named Count. Important: Change the column headers as follows: Reg Qty & Foil Qty > Count, Card > Name, Set > Edition. It won't hurt the import into Deckbox, and you can then more easily re-add the notes to Deckbox by filtering this column and going through the cards. TIP: If you have any notes saved, keep the "Notes" column. TIP: To fully delete, highlight the columns, right click, and choose Delete. Major time saver! After running the macro, pick back up at Step 12.ĭelete column A ("Total Qty"), then delete the new columns E - M ("Mana Cost" - "Price Source"). NOTE: Stop here and use the macro listed below in bburrows reply. Save your file and click "Yes" at the warning. Open in Excel (I'm using 2010, so some instructions may differ). csv (either directly by manually typing it in from your file browser, or by opening the. Many people may not need every step detailed like this, but for those that do, they'll appreciate not having to ask!Ĭhange the file extension to. I apologize for the verbosity of these instructions. I've attached your converted inventory, so that you don't have to actually go through the work, unless you want to try it yourself. I just went through the following steps, and successfully imported your inventory into Deckbox.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |