Hi,

That is something I never did but I'm assuming this can be done. I have a macro that copies data from another Workbook from specific sheets.
However, I want to copy the data from let's say wbWorkbook.sheet(1) but at the same time subtract every corresponding cells from wbWorkbook.sheet(2) and PasteAll in wZworbook.sheet(1).

Here is the code for copy and pasting one sheet. Keep in mind that the data I want to subtract is presented in a identical way so it is just to incorporate a formula into that. 

Please Login or Register  to view this content.
Thank you, if my explications are not explicit enough, please say so and I will do my best to clarify.