Copy cell contents from worksheet function

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I have a question re: Microsoft Excel 2007 :-

I have a worksheet of raw data named 'raw'.

I also have another worksheet named 'graphs'.

Is there a function available so that when a numerical value is inserted in to e.g. Cell A1 of the 'raw' worksheet, the same value will also be inserted in to e.g. Cell A2 of the 'graphs' worksheet?

The 'raw' worksheet is very large so a function would make my life much easier as opposed to just copying the cell contents from one worksheet to another!

Any help would be much appreciated!

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
one way of doing this

select sheet "raw" A1 (whehter data is ther or not) edit copyp(or control+c)

select sheet "graph" select A2 edit-pastespecial

in pastespecial window click "paste link"
click ok
now whatever you enter in raw A1 will be aultomatically entred
in graphs A2