You can also use a variable to identify the range:
Alpha = Worksheets(1).Range("A1:A3")
Then to move it to Worksheets(2):
Alpha.Copy Worksheets(2).Range("A1")
Will display the entire Alpha range on ws2.

" wrote:

Thanks in advance.

I have a set of data in excel:

Column A B C

Row 1: X Y Z
Row 2: F G H
Row 3: K L X

In another sheet, I'd like to reference these cells with "key" words.
For example, if my key word is Alpha, the First set of data should
appear in that row automatically in the new sheet (in the three
different columns, of course). Beta, the second set of data, and so
on.

How would I do this?

Thank you very much