Database creation

[garethdjohn]

Hello all

I have been asked to create a database for a manufacturing company.
Need sot be Excel based and accessible for up to 10 different people (so I presume Administrator controlled if possible?)

This company produces, sporting equipment and wants to have a database (has to be Excel) to record certain batches of items and their progress.
For example, Item A, ref No, delivery date, batch No, status, and so forth.

I think the idea is to basically quickly punch in a reference number somewhere and the database to quickly grab certain fields for that item, such as delivery date or status.

I am first of all thinking a Pivot Table maybe the best thing here?
Is it possible to have an automation button which can create said Pivot table?
Can I have a field to input a reference number to produce the above result?

I am somewhat new to Macros and programming however eager to learn!
Using Excel 2003, maybe 2007.

Thank you in advance!!

Gareth

PS: I don't have access to raw data right now, just wanting to prep work and what strategy to use.

[royUK]

You shouldn't need macros, although for multi users I would suggest MS Access

[garethdjohn]

Hi
Agreed, Access would be better.
However, the data I believe is already in Excel format, I am unsure how to transfer this over to Access.
Also, as part of this, a Dashboard report needs to be created on a regular basis, not sure how to do this via Access.

Finally, the group of persons who have access to this, do not all have Access software, each one does have Excel. I understand its to do with Licencing and wanting to keep costs down.
Finally not all know Access too well.

If as you have said, Macros are not required, what would be best way to go about this?

thanks!

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook. Don't upload a picture when you have a workbook question. None of us is inclined to recreate your data. Upload the workbook and manually add an 'after' situation so that we can see what you expect. In addition clearly explain how you get the results..
To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'.
To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

On this page, below the message box, you will find a button labelled 'Manage Attachments'.
Clicking this button will open a new window for uploading attachments.

You can upload an attachment either from your computer or from another URL by using the appropriate box on this page.
Alternatively you can click the Attachment Icon to open this page.

To upload a file from your computer, click the 'Browse' button and locate the file.

To upload a file from another URL, enter the full URL for the file in the second box on this page.
Once you have completed one of the boxes, click 'Upload'.

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[garethdjohn]

Hi Roy
When I have the data to hand I will try and upload what I have. I won't have anything for a few days however. Currently thinking about the process of what to create whats needed. Have a meeting shortly to discuss with them further what they needs.
thanks again!
G

[royUK]

You need a table in Excel with columns for specific details (fields). I would also have the left most column having a unique id number

[scantron]

You will probably want to use forms to restrict the way data is entered.