I need help creating this code, the code created works, but take too
long to process, over 10 minutes. I need to execute to function
faster.
In “sheet1” how do I find the value generated by formula in
ck145:ck148 in every instance from the source range (D5:IT7) in sheet2
named “ Sheet 11 ” and copy the contents in this sheet from
the cell in the previous column on the same row as the match to
“sheet1”, in the CL column starting on (row 145 for ck145
matches) and (row 146 for ck146 matches) and (row 147 for ck147
matches) and (row 148 for ck148 matches) .
Also, I have other worksheets I would like to update the code to query
data from into sheet 1.
rngArray = Array("D5:IT7", "D5:IT28", "D5:IT144", "D5:IT645") : sheet
11, 12, 13 and 14
OPArray = Array("ck145:ck148", "ck149:ck152", "ck153:ck156",
"ck157:ck160") :sheet1
a = Sheets("sheet " & 11 + n).Range(rngArray(n)).Value : sheet 11,
12,13 and 14

The values in ck145:ck160 are preselected by a formula and should not
be by this code. The code should go and find the matches to the values
generated by the formulas from ck145:ck160 in sheet1, to those in sheet
11, 12, 13 and 14, and place the content from the cell in the previous
column same row in each instance into the CL column of sheet1.
For example if ck145=10 in sheet1, go to sheet 11 and find all matches
in the selected range that equal 10, then for each true occurrence,
copy the content in the cell from the previous column on the same row
and paste into sheet1 starting at CL145.
Use the same function for whatever value is generated (eg. =MAX('Sheet
11'!$D$5:$IT$7)), in ck146, ck147 and ck148. Find the values from those
cells in sheet 11, then for each true occurrence, copy the content in
the cell from the previous column on the same row and paste into sheet1
starting at CL146 for the matches to ck146 and CL147 for the matches to
CK147 and CL148 for the matches to CK148.


--
dkenebre


------------------------------------------------------------------------
dkenebre's Profile: http://www.excelforum.com/member.php...nfo&userid=760
View this thread: http://www.excelforum.com/showthread...hreadid=395574