Need simple code copy/paste code

[vt804boy]

All I want to do is copy a range of cells and paste them in another spreadsheet in a specific location. Does anybody have a code that will do this. It seems simple but I am new at this. Thanks help neeeeed

 

[lox1985]

sheets("your sheet name").range("your range").copy sheets("where to paste").range("your range")

 

[vt804boy]

Ok thanks, now will this work even if its in a different file. Because I have 1 sheet that is sent to me named "Food List", it is huge and I do not need all the information that it has and I need to copy and paste certain things from it into my own inventory list called "Inventory List" which is a different file all together.

Thanks

 

[lox1985]

While you have both files open:

workbooks("Food List").sheets("your sheet name").range("your range").copy workbooks("Invetory List").sheets("where to paste").range("your range")

 

[vt804boy]

ok I will try this thank you very much for you help

 

[vt804boy]

Ok im really new to this but where do I type this into

Thanks

 

[lox1985]

In the workbook where you want it to run from ("inventory List").

Open VBE by pressing Alt - F11
On the left side you will see the files that you have open
Under the file name, right click on the name and insert a module
In the VBE window type in

sub NameOfYourSub()

Paste the code here

End Sub