How to paste to another workshhet

[Galia]

Hey,

Maybe you can help me.
I would like to paste some data to a diffrent worksheet.
For example: I have the value 100 in one cell, and I want to have this value multiply by 1.5 in the same cell in a diffrent worksheet.
How to do this?

Thank You

[RHCPgergo]

Yes, it is possible. Let's say the value of 100 is in A1 on the worksheet called Sheet1. You click the other worksheet (cell A1) and type
=Sheet1!A1*1.5

It's a simple cell reference.

[haripopuri]

It is not pasting data in other sheet. In second sheet enter a formula

Please Login or Register  to view this content.

[benishiryo]

hi Galia, welcome to the forum.
1. copy & paste values as per normal first. (eg to A1:C10)
2. type in 1.5 in another cell, maybe E1
3. copy E1
4. select A1:C10
5. right-click-> Paste Special -> Multiply -> OK

[Pete_UK]

Strange - on the New Posts list this is shown as having no posts, though clearly there are 3 responses so far.

Pete

[Galia]

Thanks! It works...

Yes, it is possible. Let's say the value of 100 is in A1 on the worksheet called Sheet1. You click the other worksheet (cell A1) and type
=Sheet1!A1*1.5

It's a simple cell reference.

[Galia]

Thank You all!!