Before u start task:
It can be either macros or formula, i don't care.
BUT it has to be exact, without any or single mistake.
Ill check it 100 times before accepting your work. make sure it works.
Payment: 30-50 depending on your work.
Here's TASK itself:
If you open PROJECT EXCEL file, you will have 2 sheets called, File1, 2.
I need formula or macros TO DO FOLLOWING:
1. GO TO FILE1,CELL B5603
2. CHECK IF CELL B5603 IS A MATCH WITH ANY ROW IN COLUMN A FROM FILE2( IN OUR EXAMPLE THE MATCH IS CELL IS A61)
3. ONCE MATCH IS CONFIRMED, THEN COPY CELL D5603(FILE1) INTO CELL A61(FILE2).
4. IF NO MATCH, MOVE TO NEXT.
REMEMBER IF YOU BID, SEND ME ANY WORK OF THIS KIND TO PROVE THAT YOU CAN DO IT.
WORK NEEDS TO BE DONE IN 24 HOURS.