Total Noob Question

[skubeedoo]

How do you copy to another excel sheet? I tried and it didn't give any values.

[weekend00]

copy.....then right click on "A1", choose paste special ->value

[weekend00]

Or:
paste you text information in Sheet1 column A,
use this formula in Sheet2, from column A to column F:
=INDIRECT("sheet1!A"&(ROW()*7-6+COLUMN()-1))

[skubeedoo]

It's perfect! Thank you very much for your help.