printing form or a database like

[jv]

Good day to everyone,

We are using a form for our equipment information totaling
about 300, the form are unique to each every equipment
only the information is different in every form. Right
now, we are in the process of expanding and adding more
equipments by the end of the year it will be totaling to
more than a thousand equipments.

Is it possible just to use one form than making a file to
every form for every equipment.

A - Fill-up.xls
1 - Equipment No.:
2 - Designation of Equipt.:
3 - Area served :
4 - Machine Location :
5 - Model:
6 - Serial No.:
7 - Supplier Name & No.:

B- Form.xls (where the info.for specific equipt.will be
shown )

From the above sample,

1 - I'll just fill up all the information required
for every equipment using just one (1) file.
2 - BROWSING - when i want to check a specific
equipment, ill just type the equipment no. and the file
and all its information will be shown in the form
(form.xls).
3 - PRINTING - when i need to print a list of
equipment ill just type the equipment nos. and all are
printed in their respective form.

Can anyone offer a help.

Thank you in advance.


jv

 

[John Wilson]

jv,

You shouldn't need two separate workbooks to accomplish what you
want to to. Without seeing what you already have, it's difficult to
tell you how to set things up.
I would think that you could have one sheet with just a database
of equipments. Each line (row) would be a specific record.
(Equip No, Designation, area served,etc.)
What you could then do on your form (separate sheet, not a separate
workbook) is use VLookups to populate the form.
e.g. On the form you'd enter the Equipment Number and all of
the other fields on the form would populate via VLookups
of that Equipment Number. Look in the Excel Help under
VLookup for a start.

John

 

[Ken Wright]

Both Data / Filter / Autofilter AND Advanced Filter would probably also help
here:-

http://www.contextures.com/xlautofilter01.html

http://www.contextures.com/xladvfilter01.html