Linking macro to cell value 1

[Tuff]

Hi guys,

I am sure it is possible to do this but I don't know how.
I want to link a cell value to the macro.
EG - Something like this.

ActiveSheet.Select"Book2"
Range("M13&quot.Select
ActiveCell.FormulaR1C1 = "Sheet"book1""C6"

How can I go about this??

 

[dyarwood]

Would it not be something like

Sheets("Sheet1&quot.select
x = Range("C6&quot.Value
Sheets("Sheet2&quot.Select
Range("M13&quot.Value = x

This will select sheet 1 and take the value from C6 into x then activate sheet 2 and put the value x in cell M13

Have I understood your question?

dyarwood

 

[Tuff]

Yep that did the trick.

Thanks