deerejon Posted June 18, 2013 Member ID: 842 Group: *** Clan Members Followers: 62 Topic Count: 278 Topics Per Day: 0.05 Content Count: 3712 Content Per Day: 0.70 Reputation: 3150 Achievement Points: 28451 Solved Content: 0 Days Won: 4 Joined: 12/06/09 Status: Offline Last Seen: April 30 Birthday: 05/04/1965 Device: Windows Share Posted June 18, 2013 Hey all... I have some issues with an excel spreadsheet and need a working template that is specific to my inventory issues, Anyone proficient in excel? Also its time to really ramp up my website...the one I have was made by my limited skill set....its for my business....this can be a paying job. Let me know if anyone interested and we can go to PM. Thanks... Link to comment Share on other sites More sharing options... Awards
Merlin007 Posted June 18, 2013 Member ID: 2068 Group: +++ COD5 Head Admin Followers: 69 Topic Count: 1075 Topics Per Day: 0.22 Content Count: 8443 Content Per Day: 1.73 Reputation: 7305 Achievement Points: 75005 Solved Content: 0 Days Won: 64 Joined: 12/25/10 Status: Offline Last Seen: 7 hours ago Birthday: 05/23/1973 Device: Android Share Posted June 18, 2013 Hey deerjon, I know excel fairly well if you want to PM me your details, I can certainly try to help you out. Link to comment Share on other sites More sharing options... Awards
LordOfChaos Posted June 18, 2013 Member ID: 3174 Group: **- Inactive Registered Users Followers: 100 Topic Count: 78 Topics Per Day: 0.02 Content Count: 2162 Content Per Day: 0.48 Reputation: 1645 Achievement Points: 17423 Solved Content: 0 Days Won: 1 Joined: 02/03/12 Status: Offline Last Seen: July 27, 2017 Birthday: 07/24/1957 Share Posted June 18, 2013 hi jon. Im pretty good with excel, and access. But if you need it for inventory management then you would be better off using access, which is meant to be used for inventory control and the like. It can also be used in tandem with excel. What i think you will need is a custom user interface that controls access to the database through specific screens that taylor your data to suit your needs. It can then be indexed according to how you want to retrieve it.. Do you enter the data yourself, or do you have employees doing it? excel and access are both fully programmable. Something i used to do in another lifetime. I hope you find what you need. In the meantime i took the liberty of finding you a few links... hope this helps! http://lmgtfy.com/?q=free+access+inventory+management+software Regards, LOC Link to comment Share on other sites More sharing options...
deerejon Posted June 18, 2013 Member ID: 842 Group: *** Clan Members Followers: 62 Topic Count: 278 Topics Per Day: 0.05 Content Count: 3712 Content Per Day: 0.70 Reputation: 3150 Achievement Points: 28451 Solved Content: 0 Days Won: 4 Joined: 12/06/09 Status: Offline Last Seen: April 30 Birthday: 05/04/1965 Device: Windows Author Share Posted June 18, 2013 @@LordOfChaos that might be a bit much for me to maintain...one freaking crash i am screwed.... What I am doing is just counting gallons...by date....so an "in" column and "out" column and total column. It does need to total at the bottom as well....and I have this basic sheet setup....but my issue is the columns for the diferent companies I track....I cant print the dates for specific customers and the printout looks just ghastly....and no dates... thanks for the come back!! Merlin is taking a look see for me at the moment.... LordOfChaos 1 Link to comment Share on other sites More sharing options... Awards
LordOfChaos Posted June 18, 2013 Member ID: 3174 Group: **- Inactive Registered Users Followers: 100 Topic Count: 78 Topics Per Day: 0.02 Content Count: 2162 Content Per Day: 0.48 Reputation: 1645 Achievement Points: 17423 Solved Content: 0 Days Won: 1 Joined: 02/03/12 Status: Offline Last Seen: July 27, 2017 Birthday: 07/24/1957 Share Posted June 18, 2013 yup i see what you mean. A very simple set up would do in excel so gl with it. Should it get a bit much for you i would recommend looking into access. it is quite a good data manager. Cheers! LOC Link to comment Share on other sites More sharing options...
2_MANY_BEERS Posted June 18, 2013 Member ID: 96 Group: ** Registered Users Followers: 107 Topic Count: 1048 Topics Per Day: 0.20 Content Count: 8812 Content Per Day: 1.64 Reputation: 3298 Achievement Points: 62176 Solved Content: 0 Days Won: 5 Joined: 09/02/09 Status: Offline Last Seen: April 29 Birthday: 06/30/1954 Device: Windows Share Posted June 18, 2013 I am the xcel wizard. I have a spread sheet that if I type the 6 numbers drawn in Powerball on it no matter how many sets of numbers I have typed in it calculates how much I won in a nano second. LOL Never won much by the way. LOL Send me file so I can fix it for ya. Beers KaptCrunch and LordOfChaos 2 Link to comment Share on other sites More sharing options...
Recommended Posts