- Feb 15, 2015
- 12
- 0
- 4,560
Im currently using Excel spreadsheets to keep track of shipments for a business but I would like something more compact, cleaner and easier to manage and something that wont become eventually unmanageable like which my spreadsheet is quickly heading towards.
The data I manage is basically categorized in either current shipments I have inbound to me and prior shipments which I have already received. Each shipment will hold information such as the senders details and the item contents which as you can image can take up from 8-20 cells vertically in Excel making for a really long, congested and hard to navigate spreadsheet. I'd like to solve this.
I uploaded a picture of a rough diagram I made of what I have envisioned for a cleaner database solution: http
/i.imgur.com/VV5IR4B.jpg
I would like to have the ability to enter shipment information similar to a html submission form and have it populate a new shipment cell for me when I submit it. I'd also like the ability to expand and close cells to see the full description of a shipment, the ability to navigate shipments based on date, to query cells based on emails, name, etc and the ability to convert cells in the "current shipments" category to the "prior shipments" category.
If anyone has any suggestions for what may be a solution I would appreciate it.
The data I manage is basically categorized in either current shipments I have inbound to me and prior shipments which I have already received. Each shipment will hold information such as the senders details and the item contents which as you can image can take up from 8-20 cells vertically in Excel making for a really long, congested and hard to navigate spreadsheet. I'd like to solve this.
I uploaded a picture of a rough diagram I made of what I have envisioned for a cleaner database solution: http
/i.imgur.com/VV5IR4B.jpgI would like to have the ability to enter shipment information similar to a html submission form and have it populate a new shipment cell for me when I submit it. I'd also like the ability to expand and close cells to see the full description of a shipment, the ability to navigate shipments based on date, to query cells based on emails, name, etc and the ability to convert cells in the "current shipments" category to the "prior shipments" category.
If anyone has any suggestions for what may be a solution I would appreciate it.
Facebook
Twitter