How to paste to another workshhet

**Galia** · 12-20-2012, 08:13 AM

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** · 12-20-2012, 08:21 AM

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** · 12-20-2012, 08:23 AM

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

Please Login or Register  to view this content.

**benishiryo** · 12-20-2012, 08:26 AM

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** · 12-20-2012, 08:44 AM

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

Pete

**Galia** · 12-20-2012, 08:49 AM

Thanks! It works...

Originally Posted by 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.