Transfering values

[peetee07]

I was wondering if it was possible to tranfer one row of values from one
worksheet to another worksheet. And is it possible to transfer one
particular cell from one worksheet to another. Thank you.

 

[macropod]

Hi,

You can copy & paste, or cut & paste, between worksheets &
workbooks, just as you can within them, with similar
results. The only major difference is that a cut & paste
between workbooks may lead to inter-workbook dependencies
that may not update automatically.

Cheers

 

[peetee07]

I'm begging here, i seriously need some help on this matter. Thank you

 

[Shaun Sheffield]

There is a book (one of many excellent ones on the subject) titled "Excel
2002 Bible" by John Walkenbach that will spoon feed you Excel from the first
steps through to advanced itermediate stage.
One good weekend buried with this book and Excel will be more fun than
Quake!

Good luck,
Shaun

 

[sam]

try just a simple cell reference (ie: =Sheet2!C5) in ur
Sheet1 cell A1... I don't know about row referencing, but
I'm sure it's just a range reference (if that's possible),
but try it and see
-sam