Need help in making a Product Database in EXCEL

[ariiiva]

Hello everyone, I am glad to join this group and take part in question and answers of excel.

There is any assignment in my company which is handed over to me and I need expert advice and suggestions.

I work in a Telecom Firm so we deal in all the telecom equipments, selling, renting and maintenance.

I have been given a assignment where in I can maintain a history/details of every single equipments.

Its like--when I put the Serial number of the machine every single detail comes up on the screen.

How can that be done in excel. Please reply, I need help.

[ashishmehra2010]

Hi Ariiiva,

Glad to have you in forum! Welcome

Try to spend some time on forum by sharing your knowledge whether you are answering or asking queries.

Try uploading a sample file with the required output before & after; so that the other person quickly understands & revert back with solution.

Regards,
AM

[MarvinP]

Hi ariiiva and welcome to the forum,

I've found material that you should review. Do all parts from this series to see if it answers some of your questions.

http://spreadsheets.about.com/od/dat...8_database.htm

[ariiiva]

Actually I am asking the question not answering, I will make use of the forum at full.

[ashishmehra2010]

Hi Ariiiva,

Check this tutorial: Excel Magic Trick #184: Setup Database in Excel

https://www.youtube.com/watch?v=WtcUYXVic-4

Regards,
AM

[ariiiva]

Database is not what I am looking for its like peoplesoft, if you have heard of it. every single details like--make, distributed to, received from, payment recieved, duedate etc. etc.

Does macro has something to do with this.