Artist work tracking program

Create a Post
MnSue

MnSue

SGF, Supreme Grumble Framer
Forum Donor
Joined
Aug 18, 2005
Posts
2,210
Loc
Minneapolis, MN
Business
Framing Solutions MN
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
 
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.
 
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.
 
BILL WARD said:
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.
Click to expand...

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
 
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?)
 
BILL WARD said:
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?)
Click to expand...

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!:)
 
Create a Post
Back
Top