Extracting with Uneven Data

[cmore]

Hi I have a sheet that has a mix of formulas and constants. On an update to another sheet that drives the formulas I need to make sure the constants stay with their associated unique ID's. So I basically do the following:

1. Load the Sheet before updates to an array
2. Loop through an outer array to check if the column in question a manual update
3. if the column is a manual update, then for each row within that column I check if the unique ID is there and then load into an array
- this is the bugger, I have no known work around to make this work faster
4. I print back to excel the array
** code below

I really need help making this faster, on avg. this file will have 200+ rows and 165 columns to check if it contains constants or formulas. Any help with how I may be viewing this or anything else, I would really really appreciate it, runtime is 20 mins + and counting.

Please Login or Register  to view this content.

[cmore]

So I'm going through the data again, and ultimately it seems like I need to find a way to extract the data from an array even though they're not necessarily the same same "length", if I could do this in one pass rather than looping I would be able to reduce the time for the loop

I have a attached a workbook with basic reference data

[cmore]

So one thing I guess I can do is identify the columns numbers for the "manual columns and then just create a loop against that limited set rather than looping through every column.