Is there an easy way to tie workbooks together?

[Marc]

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

[Ed Ferrero]

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
>
>