Copy cell contents from worksheet function

Closed
LlionRoberts - Jan 16, 2012 at 01:02 AM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Jan 16, 2012 at 05:38 AM
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

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Jan 16, 2012 at 05:38 AM
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
0