close

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!--
Intuit
------------------------------------------------------------------------
Intuit's Profile: www.excelforum.com/member.php...oamp;userid=30901
View this thread: www.excelforum.com/showthread...hreadid=505762Intuit, 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 amp; 2003

quot;Intuitquot; gt; wrote in
message ...
gt;
gt; Hello all, I'm new to this forum and it looks like this may be the place
gt; I need to be to find an answer to my question. I have a workbook that
gt; contains multiple worksheets. My goal is to enter data into one
gt; worksheets and have that data automatically transfer and update all the
gt; other worksheets with the same data so I don't have to enter it into
gt; each worksheet. Anyone know if this is possible? Thanks in advance!
gt;
gt;
gt; --
gt; Intuit
gt; ------------------------------------------------------------------------
gt; Intuit's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30901
gt; View this thread: www.excelforum.com/showthread...hreadid=505762
gt;
Intuit,

You might also look into paste specialgt; 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

quot;Intuitquot; wrote:

gt;
gt; Hello all, I'm new to this forum and it looks like this may be the place
gt; I need to be to find an answer to my question. I have a workbook that
gt; contains multiple worksheets. My goal is to enter data into one
gt; worksheets and have that data automatically transfer and update all the
gt; other worksheets with the same data so I don't have to enter it into
gt; each worksheet. Anyone know if this is possible? Thanks in advance!
gt;
gt;
gt; --
gt; Intuit
gt; ------------------------------------------------------------------------
gt; Intuit's Profile: www.excelforum.com/member.php...oamp;userid=30901
gt; View this thread: www.excelforum.com/showthread...hreadid=505762
gt;
gt;


Paul B Wrote:
gt; Intuit, group the sheets, right click on the worksheet tab an select
gt; all
gt; sheets, make your changes then right click on sheet tab and ungroup
gt; sheets
gt; --
gt; Paul B
gt; Always backup your data before trying something new
gt; Please post any response to the newsgroups so others can benefit from
gt; it
gt; Feedback on answers is always appreciated!
gt; Using Excel 2002 amp; 2003
gt;
gt; quot;Intuitquot; gt; wrote
gt; in
gt; message ...
gt; gt;
gt; gt; Hello all, I'm new to this forum and it looks like this may be the
gt; place
gt; gt; I need to be to find an answer to my question. I have a workbook
gt; that
gt; gt; contains multiple worksheets. My goal is to enter data into one
gt; gt; worksheets and have that data automatically transfer and update all
gt; the
gt; gt; other worksheets with the same data so I don't have to enter it into
gt; gt; each worksheet. Anyone know if this is possible? Thanks in
gt; advance!
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Intuit
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Intuit's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=30901
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=505762
gt; gt;This worked great! Your awesome! You just saved me a possibly big
headache! Thanks!!!!!!!!!!!!--
Intuit
------------------------------------------------------------------------
Intuit's Profile: www.excelforum.com/member.php...oamp;userid=30901
View this thread: www.excelforum.com/showthread...hreadid=505762
Paul B Wrote:
gt; Intuit, group the sheets, right click on the worksheet tab an select
gt; all
gt; sheets, make your changes then right click on sheet tab and ungroup
gt; sheets
gt; --
gt; Paul B
gt; Always backup your data before trying something new
gt; Please post any response to the newsgroups so others can benefit from
gt; it
gt; Feedback on answers is always appreciated!
gt; Using Excel 2002 amp; 2003
gt;
gt; quot;Intuitquot; gt; wrote
gt; in
gt; message ...
gt; gt;
gt; gt; Hello all, I'm new to this forum and it looks like this may be the
gt; place
gt; gt; I need to be to find an answer to my question. I have a workbook
gt; that
gt; gt; contains multiple worksheets. My goal is to enter data into one
gt; gt; worksheets and have that data automatically transfer and update all
gt; the
gt; gt; other worksheets with the same data so I don't have to enter it into
gt; gt; each worksheet. Anyone know if this is possible? Thanks in
gt; advance!
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Intuit
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Intuit's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=30901
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=505762
gt; gt;This worked great! Your awesome! You just saved me a possibly big
headache! Thanks!!!!!!!!!!!!--
Intuit
------------------------------------------------------------------------
Intuit's Profile: www.excelforum.com/member.php...oamp;userid=30901
View this thread: www.excelforum.com/showthread...hreadid=505762Your 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 amp; 2003

quot;Intuitquot; gt; wrote in
message ...
gt;
gt; Paul B Wrote:
gt;gt; Intuit, group the sheets, right click on the worksheet tab an select
gt;gt; all
gt;gt; sheets, make your changes then right click on sheet tab and ungroup
gt;gt; sheets
gt;gt; --
gt;gt; Paul B
gt;gt; Always backup your data before trying something new
gt;gt; Please post any response to the newsgroups so others can benefit from
gt;gt; it
gt;gt; Feedback on answers is always appreciated!
gt;gt; Using Excel 2002 amp; 2003
gt;gt;
gt;gt; quot;Intuitquot; gt; wrote
gt;gt; in
gt;gt; message ...
gt;gt; gt;
gt;gt; gt; Hello all, I'm new to this forum and it looks like this may be the
gt;gt; place
gt;gt; gt; I need to be to find an answer to my question. I have a workbook
gt;gt; that
gt;gt; gt; contains multiple worksheets. My goal is to enter data into one
gt;gt; gt; worksheets and have that data automatically transfer and update all
gt;gt; the
gt;gt; gt; other worksheets with the same data so I don't have to enter it into
gt;gt; gt; each worksheet. Anyone know if this is possible? Thanks in
gt;gt; advance!
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; Intuit
gt;gt; gt;
gt;gt; ------------------------------------------------------------------------
gt;gt; gt; Intuit's Profile:
gt;gt; gt; www.excelforum.com/member.php...oamp;userid=30901
gt;gt; gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=505762
gt;gt; gt;
gt;
gt;
gt; This worked great! Your awesome! You just saved me a possibly big
gt; headache! Thanks!!!!!!!!!!!!
gt;
gt;
gt; --
gt; Intuit
gt; ------------------------------------------------------------------------
gt; Intuit's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30901
gt; View this thread: www.excelforum.com/showthread...hreadid=505762
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()