Copy To Another Sheet using Selection, Selection

[dantb]

Hello all: The below Code works fine if your copying and running from the same worksheet that you are copying from, but what can I add to run the (code on one Sheet1 and have it copy the data on Sheet 2)? Have tried
Sheets("Sheet2").Range("E17").Selection , Selection.End(xlUp).Copy, but missing something. Thanks Dan



Range("E17").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy

 

[Norie]

Dan

What/where are you copying/pasting from/to?

 

[dantb]

Hello Norie:
The excact place of copy paste will be: Run from sheet (FinalSortFilter), and copying data from sheet (Final) starting at range 1956 Down to the last cell that has data in it. I figured if I gave a example I could edit for my needs. Thanks Dan