Copy cell contents from worksheet function [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
793
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!