Artist work tracking program

[MnSue]

My new PT employee is an artist with work in many galleries across the country, along with ebay, etc.

She is trying to find a inventory type program to assist her in the tracting for her gallery pieces and her general inventory of artwork available through all her venues.

Any suggestions? thanks

[mik]

She could easily set up a Excel spreadsheet to track her inventory. Each gallery would have its own worksheet or page, with as much info as she needs to record. Excel will allow some basic type of sorting.

If she wants a true "data base" program, do a google search on "free database software" or "freeware". She might be able to find a free db program that fits her needs and is easy to use.

[Garnetta]

I use Working Artist and would recommend it.

http://www.workingartist.com/

[BILL WARD]

MIK-
if using seperate sheets is there a function to auto-sum each column on, say, page 1?-----would really be of benefit for getting total-totals.

[mik]

MIK-
if using seperate sheets is there a function to auto-sum each column on, say, page 1?-----would really be of benefit for getting total-totals.

To total each column, use use "AUTO SUM" , located on the Excel tool bar. Highlight the column of numbers you want to total, include a blank cell at the bottom, click on AUTO SUM and there is your total. You can also total across the columns, giving grand totals. How this helps

[BILL WARD]

knew about auto-sum, I was thinking about col sums for ALL worksheets, the total of ALL sheets being shown on a designated sheet(probably #1?)

[mik]

knew about auto-sum, I was thinking about col sums for ALL worksheets, the total of ALL sheets being shown on a designated sheet(probably #1?)

I thought that might be what you wanted but wasn't sure. So here goes:

If you want the total from a column on sheet 1 on a different worksheet, say sheet 4:
highlight a cell on sheet 4 where you want the data and type the following formula: =SUM(Sheet1!A12) where the total on sheet on is located in A12.

Here is a sample of the formula you would use to add two columns totals from sheet 1, two columns from sheet2 where the totals a located in cell A12,B12 on each sheet.

=SUM(Sheet1!A12,Sheet1!B12,Sheet2!A12,Sheet2!B12)

"sheet 1" is the tab name which you can rename to Gallery A, Gallery B etc.


Headings can be copied directly from one sheet to another.
Remember to use commas to separate the different references.

You can also play with "Pivot Tables" to make more elaborate reports.

Hope this helps!:)

[Pat Murphey]

You can write formulas that refer to cells or ranges on multiple sheets.

Beat me mik.

[mik]

Sorry!

[MnSue]

Cecilia says THANK ALOT! This was really helpful.