close

I would like for some calculated results from cells in one worksheet to
automatically be entered into similar cells in a different worksheet.
As it stands now I have to transfer the data by hand each month, making
the data much more susceptible to error. How can I do this? Thanks!Would the following do?

say in B3 on sheet2 put

=Sheet1!A2

where A2 is a calculated cell in sheet1
quot; wrote:

gt; I would like for some calculated results from cells in one worksheet to
gt; automatically be entered into similar cells in a different worksheet.
gt; As it stands now I have to transfer the data by hand each month, making
gt; the data much more susceptible to error. How can I do this? Thanks!
gt;
gt;

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

    software

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