Hello - I would like to subtract two ranges using vba macro and post the difference to a new sheet. Specifics are as below:
Specifics: The data sets are large in size - It has 600 rows of products by 12 columns of months for close to 10-15 countries. And data set of each country is in one tab
Data Set :
Product Region Jan Feb Mar Jan Feb Mar
Pepsi Germany 10 15 20 5 10 5
Result: In a new workbook/worksheet
Product Region Jan Feb Mar
Pepsi Germany 5 5 15
I tried by using ARRAY but I think it will be very slow trying to read line by line, cell by cell, calculate the difference and paste it in new sheet.
Could some one recommend a faster method to do - where we can read the two data sets in one go, do the calculations in memory and post the results.
My logic: This is just sample with 20 rows for one country. But I will need to loop around all the countries.
Thank you.Please Login or Register to view this content.
Bookmarks