Using ranges from two worksheets

[ihf]

I would like to perform a calculation with each cell in a range from 2 worksheets and place the result in a range on a third worksheet. I thought I could use the For Each Cell in Range construct but I don't see how to reference the two ranges in a nested pair of For loops. I am sure there must be an simple/elegant way to do this. Can anyone tell me the best way to do this?

[royUK]

Can you explain a little more what you mean. maybe attach an example workbook with some test data in

[ihf]

I have numbers in a range (say A1:K15) on Worksheet 1 and a set of numbers in the same range on Worksheet 2. I want to create a third worksheet with the same range populated with the difference (or percentage change) for each cell in that range.

[royUK]

You don't need a macro to do that.

[ihf]

I actually do need a macro because as part of the loop I need to test each cell to determine its type and to do the appropriate thing with each pair of cells (e.g., to copy strings as is). I just need to know the best way to reference the cells in ranges on 2 worksheets in a loop.

[ihf]

I also need to use a macro because I need to prompt the user for the names of the two workbooks form which the calculations will be done.

[shg]

One of many ways ...

Please Login or Register  to view this content.

[ihf]

PERFECT!

Thank you!