View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Living the Dream Living the Dream is offline
external usenet poster
 
Posts: 151
Default A unique ID for each row, also automatically after inserting anew row.

Hi Ronald

Firstly, Is this meant to be a form of Inventory Control for Inwards & Sales/Dispatch?? If so, this would be far more efficient if it was in a database, that aside.

Your structure is ( IMO ) slightly skewed, here's why. It would be better served as follows:

Category No:
Product Code:
Item Code:
Box Qty:
Box Size:
Box Color:
Brand:
Supplier:
Movement Type: ( In / Out )
Date:

The reason for the date is it covers the date/time when the product was added to, or moved out of stock.

I could be way off the mark here, and someone else may have something more to your liking. Personally myself, an MSAccess Database or similar DB like MYOB ( which has in/out stock control ) may be a better solution as it keeps all your records in one container where all activity is recorded.

HTH

Cheers
Mark.