Is there an easy way to tie workbooks together?
 

I realize that there are other ways to achieve the results I'm looking for
but I don't have time to learn anything else. I tried to have one workbook
the first "section" you entered customer information and work that needed to
be done by floor than room, the next "section" and the numbers were enter by
links from the first "section" security system layouts, than telephone,
cable and networking than audio and home theater, than intercom and central
vac. These were link to a worksheet with quotes and finally one "section"
for work orders. This thing is huge and hard to manage so I was thinking
about using separate workbooks for each section but that means that I would
have to rename 6 workbooks for each quote and that ridiculous. Is there an
easy way to do what I want to accomplish?

Marc

Hi Marc,

There is an Excel "database' tutorial here
http://edferrero.m6.net/DataTutor01.shtml

It may help.

Ed Ferrero
http://edferrero.m6.net/

I realize that there are other ways to achieve the results I'm looking for
but I don't have time to learn anything else. I tried to have one
workbook
the first "section" you entered customer information and work that needed
to
be done by floor than room, the next "section" and the numbers were enter
by
links from the first "section" security system layouts, than telephone,
cable and networking than audio and home theater, than intercom and
central
vac. These were link to a worksheet with quotes and finally one "section"
for work orders. This thing is huge and hard to manage so I was thinking
about using separate workbooks for each section but that means that I
would
have to rename 6 workbooks for each quote and that ridiculous. Is there
an
easy way to do what I want to accomplish?

Marc