S
sal21
I have this 2 sheets:
GAF
CORPORATE
How to matching range H:N into CORPORATE with the column H in GAF and when
the value into range H:N is found in column H of GAF insert the line into
template the value of cells..
Example:
Into range H2:N2 of CORPORATE are present: 1, 2, 3, 4, 6, 7, 15
into column H of sheet GAF are present many cells with the same value 1, 2,
3, 4, 6, 7, 15
Copy all line matched in TEMPLATE
Finished the first range of matching go to next line of CORPORATE range
H3:N£ clear the value into TEMPLATE amnd insert the new value amtched with
the same tecinque...
Do until the value in E of CORPORATE is blank...
Attached a TEMPLATE with the value of first rangeH2:N2 of CORPORATE
hope i am clear.
Attaced example
http://www.mytempdir.com/970855
GAF
CORPORATE
How to matching range H:N into CORPORATE with the column H in GAF and when
the value into range H:N is found in column H of GAF insert the line into
template the value of cells..
Example:
Into range H2:N2 of CORPORATE are present: 1, 2, 3, 4, 6, 7, 15
into column H of sheet GAF are present many cells with the same value 1, 2,
3, 4, 6, 7, 15
Copy all line matched in TEMPLATE
Finished the first range of matching go to next line of CORPORATE range
H3:N£ clear the value into TEMPLATE amnd insert the new value amtched with
the same tecinque...
Do until the value in E of CORPORATE is blank...
Attached a TEMPLATE with the value of first rangeH2:N2 of CORPORATE
hope i am clear.
Attaced example
http://www.mytempdir.com/970855