vhuang
09-24-2013, 08:07 AM
Hi,
I came across some similar threads but unfortunately have not been able to "crack the code" and keep on getting a #value error.
I am able in excel to write the index-match array formula but unfortunately, my data set is so large that it either crashes my computer or takes 30-40 minutes to process the action.
I'm hoping to find a vba code to alleviate the stress of the processing.
My data set looks a bit like the attached spreadsheet where I have data from the "Data dump" spreadsheet that needs to be re-organized into the "extracted" spreadsheet. If the value from the "data dump" is null, I would like the quantity to show 0. I need to have the quantity showing up below the country headers in columns K&L on the extracted tab.
I've been trying to get the script to work all day with no luck.
any help would be appreciated!
I came across some similar threads but unfortunately have not been able to "crack the code" and keep on getting a #value error.
I am able in excel to write the index-match array formula but unfortunately, my data set is so large that it either crashes my computer or takes 30-40 minutes to process the action.
I'm hoping to find a vba code to alleviate the stress of the processing.
My data set looks a bit like the attached spreadsheet where I have data from the "Data dump" spreadsheet that needs to be re-organized into the "extracted" spreadsheet. If the value from the "data dump" is null, I would like the quantity to show 0. I need to have the quantity showing up below the country headers in columns K&L on the extracted tab.
I've been trying to get the script to work all day with no luck.
any help would be appreciated!