Help! I need to create worksheets to connect?
 

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

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

"Tess" wrote:

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

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

Tess wrote:

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

--

Dave Peterson

Tess,

Though the above poster's reply would work, from what I read, it seems
overkill for what you are asking.

First, I'd recommend you pick up a beginner's book on Excel, because,
as I read your post, you are asking a question that is Excel101, no
insult intended.

To illustrate,

1. In the first place on a different sheet that you want a value read
from your input sheet, type an equals sign.

2. Now click the tab and then click the cell that contains the source
input.

3. Press your Enter key.

Now, whatever value you enter on your input sheet is immediately echoed
to your calculations sheet.


--
nbrcrunch

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!

"nbrcrunch" wrote:


Tess,

Though the above poster's reply would work, from what I read, it seems
overkill for what you are asking.

First, I'd recommend you pick up a beginner's book on Excel, because,
as I read your post, you are asking a question that is Excel101, no
insult intended.

To illustrate,

1. In the first place on a different sheet that you want a value read
from your input sheet, type an equals sign.

2. Now click the tab and then click the cell that contains the source
input.

3. Press your Enter key.

Now, whatever value you enter on your input sheet is immediately echoed
to your calculations sheet.


--
nbrcrunch