Populating Multiple Worksheets with one entry

I

Intuit

Hello all, I'm new to this forum and it looks like this may be the place
I need to be to find an answer to my question. I have a workbook that
contains multiple worksheets. My goal is to enter data into one
worksheets and have that data automatically transfer and update all the
other worksheets with the same data so I don't have to enter it into
each worksheet. Anyone know if this is possible? Thanks in advance!
 
P

Paul B

Intuit, group the sheets, right click on the worksheet tab an select all
sheets, make your changes then right click on sheet tab and ungroup sheets
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
H

Heidi

Intuit,

You might also look into paste special> link and see if that does what you
want. It pastes a link to the original data so that if your original data
changes, the cell containing the link will change as well.

Heidi
 
I

Intuit

Paul said:
Intuit, group the sheets, right click on the worksheet tab an select
all
sheets, make your changes then right click on sheet tab and ungroup
sheets
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from
it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

in
message news:[email protected]...
Click to expand...


This worked great! Your awesome! You just saved me a possibly big
headache! Thanks!!!!!!!!!!!!
 
I

Intuit

Paul said:
Intuit, group the sheets, right click on the worksheet tab an select
all
sheets, make your changes then right click on sheet tab and ungroup
sheets
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from
it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

in
message news:[email protected]...
Click to expand...


This worked great! Your awesome! You just saved me a possibly big
headache! Thanks!!!!!!!!!!!!
 
P

Paul B

Your welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top