Copy cell contents from worksheet function

Closed
LlionRoberts - Jan 16, 2012 at 01:02 AM
venkat1926 Posts 1863 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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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