I have a comand that works just fine for copying and
pasting within a single worksheet. In the following
code, I want the E2:H data to be in sheet2 and I want the
A2:D data to be from sheet 1. How would I incorporate
that? Thank you.



Range("E2:H" & FinalRow).Value = Range("A2:D" &
FinalRow).Value