View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jono2000 Jono2000 is offline
external usenet poster
 
Posts: 3
Default Best way to manipulate CSV files

i need to create a feature in excel where i can merge two csv files, based on
a key field in both files, ie where smith in file a matches smith in file b,
then take the 4th value from file b and add it to the third value in file A.

very relational.

given i've only got excel and vba and 2 csv files to do this in whats the
best way of going about it, architecturally speaking!!