Excel and Stock Sheets :(

[Pheebs]

I *hate* excel.

Currently trying to fudge together something a little more useful than what I've already got for stock check of my greeting cards. (Noobs - I design and sell greeting cards and will soon be trialling in Clintons).

I think I've looked and thought about it so much that I'm now just over complicating it so am hoping one of you genius people will say "stop being a div, just do this this and this!"

What I have and need to be able to do with these sheets:

I have long (and forever growing) lists of greeting card designs and their codes. They're all categorised (so under "seasonal" or "love" or "chocolate" etc).

I will have lots of clients (and hopefully will get some more soon) who will be ordering in cards whenever they require (could be any day of the week). Some will be doing sale or return - so if they do order a batch, I may well get a load back which I will need to record to go back onto my stock.

Obviously need to account for damaged items too.

I will need daily updates on figures and where I can hopefully figure out easily what's selling best etc.



It sounds simple but with all the customers - I'm going to need a day by day, month by month update for all of them with sale and returns. I just can't think how to practically put it on a spreadsheet without it becoming massive and confusing.

Damn me for having far too many designs

I have some ideas and have half done one but it's very confusing and just over crowded and soooo I would be intrigued to know how you bright sparks would lay it out.


(and yes I know I should get someone to design me a proggy but I have zilcho dosh to spare for things like that )