linking 2 sheets?

[nikko50]

Hi guys! Hope your New Year has started out great!

My question is I want to create a macro which I'll code in VBA to take a few cells from one open worksheet in a particular tab and copy them over to another open worksheet named "Final" into another particular tab. I'm sure it's possible with some VBA magic but need to know where to start or if someone can give me a quick few lines of code and I'll take it from there. Thanks Tracy!

 

[venkat1926]

"open worksheet"
I think you mean open workbooks


both workbooks open
this is only a SAMPLE macro
modify to suit you

with workbooks("book1").worksheets("sheet1")
.range("A1:A3").copy
with workbooks("Book2").workshkeets("sheet2")
.range("A1").pastespecial
end with 
end with