Is Excel For My Company?

[AC3AROD]

Hey

Basically, my company is a consulting firm. We find customers and match them up with vendors. What I'm looking for is a database program where I can enter information into, such as customer, vendor, purchase order number, our file number and delivery date, and have that information put on 2 different sheets for each of our vendors. One sheet would display information on significant to myself (who the customer is, our PO to the vendor, our customers expected delivery date, etc.) and one sheet significant to our vendor (the date we sent them a purchase order, their expected delivery date, etc.)

I'm using excel for this now but it is too complicated and time consuming. I have 10 different sheets opened on one workbook (i.e. sheet 1 links with sheet 6, sheet 2 with sheet 7 and so on). So I'm looking for something different.

What would be ideal is to have some sort of programmed database that does all this for more after I enter in some predetermined information (such as vendor, customer, our PO, customer PO, delivery date, status, part number).

Sorry for the confusion if it doesn't make sense. I'd be more than willing to explain in further detail via email.

Thanks
Aaron
[email protected]

[mewingkitty]

Sounds like you need to conglomerate some informations.

With some help from the nice peeps on here, some trial and error, and a lot of data entry, I've set up a PO sheet which allows me to reference product codes and costs from 8 different suppliers, including unique product codes for similar products from different manufacturers, tally my costs for the items from multiple suppliers at once, generate PO sheets for each supplier at the same time, and tell me how much more I need to order to meet my prepaid from each place.

This is done on one sheet, with a singe click to choose a supplier, and one number entry to choose quantities.

I'm fairly convinced that pretty much anything can be done with Excel, it's getting the initial layout established the first time around that takes some serious effort, after that it's eezy peezy.

mew!

[AC3AROD]

back to the top

[AC3AROD]

Hey

Basically, my company is a consulting firm. We find customers and match them up with vendors. What I'm looking for is a database program where I can enter information into, such as customer, vendor, purchase order number, our file number and delivery date, and have that information put on 2 different sheets for each of our vendors. One sheet would display information on significant to myself (who the customer is, our PO to the vendor, our customers expected delivery date, etc.) and one sheet significant to our vendor (the date we sent them a purchase order, their expected delivery date, etc.)

I'm using excel for this now but it is too complicated and time consuming. I have 10 different sheets opened on one workbook (i.e. sheet 1 links with sheet 6, sheet 2 with sheet 7 and so on). So I'm looking for something different.

What would be ideal is to have some sort of programmed database that does all this for more after I enter in some predetermined information (such as vendor, customer, our PO, customer PO, delivery date, status, part number).

Sorry for the confusion if it doesn't make sense. I'd be more than willing to explain in further detail via email.

Thanks
Aaron
[email protected]

[shg]

Threads merged. Please don't duplicate posts.

I expect the reason you're not getting much response is that the question is impossibly general, and no one is likely to want to take the time to extract what you have in mind with 20 questions.