I gang

2008.08.04 Excel project

I have an Excel macro which doesn't seem to be performing properly. You have to choose a "txt" file in the first field and then the "csv" file in the second and click "GO". The macro will compare the names of various mobile phones in the first row of each file, and then insert prices from the "txt" file into the "csv" file when a match is found.

The prices for some phones are correctly processed, but not the prices for others. The names of the phones in each file should be exactly the same. There is no partial matching, only exact matching. On the other hand, discrepancies with spaces or capitalisation might be allowed. However, in this case I think the names exactly match, and yet the prices are not replaced for one of the phones.

The project is to investigate why, and to fix the problem.

Færdigheder: Excel

Se mere: match problem, excel &, macros excel project, excel project wanted, excel project bidding, excel project log, excel project network, n excel, macro excel, macro + excel, fix excel macro, excel\ , excel, excel project, excel c#, insert macro excel, excel macro txt, excel macro row, excel macro csv, insert txt, fix excel, project macro, match prices, excel compare names, excel compare row

Om arbejdsgiveren:
( 92 bedømmelser ) Dun Laoghaire, United Kingdom

Projekt-ID: #295762