Copying data from two sheets into a new sheet

[roshukha]

Hi,

I have a excel workbook with three active sheets, where "Sheet 3" cell values are product of cell values from "Sheet 1" and "Sheet 2". For example, in "Sheet 3", cell A1 value = Sheet 1 A1 * Sheet 2 $A1.

I want to find those cell values using VBA.


The excel file is attached.


Thanks in advance.


Excel Forum.xlsx

Roshu

[Arkadi]

Find those values? or calculate and paste those values?
You don't give enough detail here about what you want the code to do.

My basic guess:

Please Login or Register  to view this content.

[roshukha]

I want the values of Sheet 3 Cell range A1:KD952.

[Arkadi]

So column B on Sheet1 is multiplied by Sheet2 Column A also? and pasted in Col B of sheet3? all the way to KD?

[roshukha]

So column B on Sheet1 is multiplied by Sheet2 Column A also? and pasted in Col B of sheet3? all the way to KD?

Yes, that's what I am looking for.

[Arkadi]

So sheet 2 does only have 1 column? Just want to make sure

[roshukha]

So sheet 2 does only have 1 column? Just want to make sure

Yes, only one column in Sheet 2.

[Arkadi]

Ok maybe this then:

Please Login or Register  to view this content.

[roshukha]

It is working.

Thanks a lot Arkadi.

[Arkadi]

Your're welcome, thanks for marking as solved, and the rep