Help! I need to create worksheets to connect?

[Guest]

I have a workbook with multiple worksheets in it (Invoice, Job records,
Quotes, Takeoffs, etc.) I want to be able to connect them all as in when I
enter data in one sheet I want it to automatic enter into the other
worksheet.

EG: I do my takeoff on my worksheet to get totals and description of work to
be done, I want to know if it is possible to automaticly have that
information put into my quote (template) so I can send that off to my
customer?

Thanks

 

[Guest]

Or is there another program that may be better to perform this kind of
process???

 

[Dave Peterson]

First, I'd use one worksheet as the input sheet.

Then I'd put a button from the Forms toolbar on it that had a macro assigned to
it that would copy all the input to the various sheets.

If you post back with a little more information (locations of the "from" data
and locations of the "to" data). (Locations = worksheet names and cell
addresses for each field.)

 

[Guest]

Thanks guys for the input, but I figured it out. I knew how to do the = and
enter scenario, but what I did do was the information I wanted to
automatically input in other worksheets in various areas was copy then paste
special, and linked the cells.

Thanks though!