applying cross referencing between files?

[jafooli]

hi, im after some help or helped to be pointed in the right direction. is it at all possible to setup something that when I input my times into my sheet it copies the selected data and puts it into a different sheet? the sheet would not be in the same file name? hope that makes sense

many thanks

[NickyC]

Hi

try this code, substituting the name of your source and destination files and the sheets and addresses to copy from and to

Sub copy_value()
Workbooks("source.xls").Sheets("Sheet1").Range("A1").Copy Destination:=Workbooks("destination.xls").Sheets("Sheet2").Range("A2")
End Sub

[jafooli]

Hi

try this code, substituting the name of your source and destination files and the sheets and addresses to copy from and to

Sub copy_value()
Workbooks("source.xls").Sheets("Sheet1").Range("A1").Copy Destination:=Workbooks("destination.xls").Sheets("Sheet2").Range("A2")
End Sub

ok thanks NickyC. Where do I put the above code in?... sorry if this is a dumb question. ive got both spreadsheets open side by side. thanks for your help

[jafooli]

can anyone else have some input please? cant quite figure out where excatly this code goes. im such a noob

[Domski]

The code would go in a regular vba module: http://www.contextures.com/xlvba01.html

You can then easily run the code by clicking a button from the Forms toolbar.

Dom