dreknapalci
New Member
Hi,
In 'Data' you have column with title F and one with title A. You have “source”. I need to process the source and to fill the sheets “F” and A” :
In the 'source' you for example this line (row 9):
TV10,
506778003,
40900720163
,03-09-2015, 22:46:16,
66,
1
Since the 40900720163 appears in “Data” under F, I want to add the +972506778003 in sheet “F” (if 40900720163 was under “A” I would add it to sheet A).
Thats it.
Can it be made with a button to process it every time I change the content of “Source” or “Data”. Can it be done without VBA (I dont mind vba or formulaes...)
Thanks!
In 'Data' you have column with title F and one with title A. You have “source”. I need to process the source and to fill the sheets “F” and A” :
In the 'source' you for example this line (row 9):
TV10,
506778003,
40900720163
,03-09-2015, 22:46:16,
66,
1
Since the 40900720163 appears in “Data” under F, I want to add the +972506778003 in sheet “F” (if 40900720163 was under “A” I would add it to sheet A).
Thats it.
Can it be made with a button to process it every time I change the content of “Source” or “Data”. Can it be done without VBA (I dont mind vba or formulaes...)
Thanks!