Hi there!

I'm Eni Oken, artist and author of hundreds of articles, tutorials and books in print and online. For over 30 years I've explored art, color theory, fantasy and ornamental design.

Certified Zentangle® Teacher

Certified Zentangle® Teacher

Jewelry Calculator: saving worksheets versus workbooks

I received the following question via email regarding usage of the Jewelry Calculator:
>>>Is there any way to save data on a jewelry item without having to open a new workbook? It seems the only way to log information using your spreadsheet is to use the SaveAs feature and save a whole new xls file and then open the original workbook again and start over for each new piece. Is there a way to get it all to save in the same workbook on separate sheets so that it's all in one file perhaps?

The answer: I normally save a whole new worksheet, but this is how you can save a new worksheet:
Click and DRAG the tab called "Jewelry Price Calculator", located at the lower left corner of the calculator. You will see a small sheet of paper on the cursor. Press the CTRL button and you will see a small plus sign inside the sheet. Let go and a duplicate of that worksheet will appear!

Alternative LONG ROUTE:
1) Click with the RIGHT BUTTON of the mouse on the lower left tab named "Jewelery Price Calculator". A small menu will appear, select "Move or Copy".

2) A small dialog box will open. Make sure the option "Create a copy is selected".

3) A new tab called "Jewelry Price Calculator (2)" will appear. Click with RIGHT BUTTON of the mouse again, and this time select "Rename".
4) Type the new name of the new Worksheet. Now you can keep all your calculations in the same workbook.
This is especially useful if you have similar products or want to compare different alternative solutions to pricing a piece.
To check out the calculator, go here: Jewelry Price Calculator for Excel.

Wire: dead soft or half-hard?

FSOJ 2008 Week 14: Beadcruise pendant