Good Afternoon,
I run a restaurant company and would like to roll out a sequestialed purchase order system to better track expenses. I would like to have a file that can be accessed on the network, a user could open file and push button to create a new purchase order. They would have to fill out the supplier, date of purchase, amount, description, and user name. I would like a PO number and the date of creation to auto populate. I would then like the created PO's tracked in the same file just on a seperate protected sheet. Can anyone help me with this as I am not really sure where to begin.
Thanks in advance for your help.
Michael
How many users / locations / different PCs would this need to run on at the same time?
Would PO #s need to follow order from different locations? ie, user#1 in location#1 places PO#114, user#2 in location#2 places an order with PO#115?
This is a pretty big request in one chunk. I'm sure you'll get better response if you break down your question into several parts, so that they can be tackled one after the other.
Also, we're happy to help you with your effort, but nobody here will be keen on developing a solution from scratch. This forum is about helping people learn how to use Excel, not a free development service.
Have you started any work on this project yet?
How far did you get?
Where are you stuck?
We can help you develop your own code, but if you want someone to code this for you all the way, you should try and find a commercial developer.
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks