DATA ENTRY - EXCEL / ACCESS / VBA
$30-250 USD
Płatność przy odbiorze
I have another job thats similar but it involves more searching. here are details/instructions:
attached excel doc has three sheets,
1- keywords to search
2- data needed
3- sheet to search from column H and input appropiate data in adjacent cells.
appropiate data comes from sheet 2
here are the steps:
1- search keyword list (in sheet 1) in column H (in sheet 3). VERY IMPORTANT - ONLY SEARCH EXACT PHRASE, DO NOT FIND TEXT INSIDE WORDS. SEPARATE MORE THAN 1 RESULT FOUND BY SLASHES "/".
2- SHEET 2 HAS THREE COLUMNS, 1 BATTERY MODEL #, 2 BRAND, 3 UNIT MODEL #. IF SEARCH FINDS A RESULT FROM COLUMN B AND COLUMN C, THEN ENTER BATTERY MODEL NUMBER FROM COLUMN A IN CELL OF COLUMN G (IN SHEET 3). ONLY IF SEARCH FINDS 2 RESULTS - AT LEAST 1 IN COLUMN B AND, NOT OR, AT LEAST 1 IN COLUMN C, SHOULD BATTERY MODEL # BE ENTERED. IF DATA IS FOUND IN ONLY 1 COLUMN - EITHER B OR C, THEN ENTER THIS DATA BUT DO NO ENTER BATTERY MODEL NUMBER.
PLEASE SEE EXAMPLES I'VE INCLUDED IN SHEET.
Numer ID Projektu: #829921
O projekcie
Przyznany użytkownikowi:
37 freelancerów złożyło ofertę za $56 w tym projekcie
Hello, a solution in Excel VBA (2003 / 2007) will do the job. I will deliver in 1 day only. Thanks.
Sir, I am very interested. I have gone through with the requirements you described in your detail. I can easily do it with our expertise.I shall provide you regular updates during progress, if I get this.... And Więcej