Need a macro to subtract cell values of 2 separate workbooks.

[Cindyberlindeee]

Hi,

Not sure if it's possible to create a macro like this, but i wanted to ask anyway.

I have 2 workbooks.
Workbook 1: Has a table of cell values (with 8 rows and 4 columns in cell range B2:E10)
Workbook 2: Has a similar table of cell values (also with 8 rows and 4 columns in cell range C15:F22)

Now, i want to create a macro which will subtract all the cell values in workbook 1 with the corresponding cell value in workbook 2. For example, I want to do the calculations B2-C15, C2-D15, B3-C16 etc.

I would really appreciate any help, thanks!

[sky1in5]

Please Login or Register  to view this content.