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;
- Apr 13 Sun 2008 20:43
Simultaneous entry of data between 2 different worksheets
close
全站熱搜
留言列表
發表留言