Sup I have a few questions about making forms in either excel or word.

My womans dad asked me to make a few forms for his business(Tool and Die shop). He currently does everything by hand which is a total waste of time.

Heres what he wants.

Each job that he does has about 5 forms associated with it. Each form at the top has pretty much the same information (customer name, PO # date, Job #, ect) then the bottom each form varies. In college we made forms in excel but Im a little rusty and need a little direction which way to go with this.

I guess what would be ideal is to open up a file and have all the forms linked(if this is possible) So when I fill out all the information on the first form it links to all the other forms (customer name, PO #,,,ect). I know excel does that but dont know about word.

Just looking for some feedback on which would be easier to work with and any additional information. Thanks guys. :af:

 

excel would be the way to go. you can have different worksheets in the same file and have the data link between them all.

 

i guess u can have all the worksheets in one excel document linked assuming u need these printed out
just have the cells in the other worksheet reference the first one

 

Thanks guys.

So excel it is. Do you recommend messing around with the VBA macros at all?

 

you probably could, but i don't know that you would have to.

 

how about just getting all the 5 forms already used before... white-out the info/specs and just photocopy them all? h: