What I have :I have CSV file with several columns and rows.
What I need: I need some sort of script or macros to dynamicly add another column to the CSV file that would contain values based on the value of the given (first or second or third) column and row.
Example: I have A,B,C and D columns and 7 rows. I need to convert this CSV that after conversion is done every row that has value of 407 in position d would have column I added with value 2,every row that has 1037 in position D would have value of 30 added to column H and so on.
The macros should be fully ajustable based on what I need.
In example file that I attached to this ad I need macros to create column I values based on column [login to view URL] every row that has 437 in D i need have row value of 10(or whatever) in column I and so on.
I will have to process csv files that has 500 or 600 lines so macros should be able to process huge ammount of information.
AND I need macros to save newly created file in CSV.
Also I need macros to save my parameters for conversions,say today I have above requirements,tomorrow I will have another requirements(different values or different columns ).I want to be able to save requirements for later load and use.
30 freelancers estão ofertando em média $63 para esse trabalho
HI; i m the best expert in VB6 and office VBA. i have done similar tasks on XLS. u can check my profile here: [login to view URL] Best Regards; Hussien Sharaf
sir, i promise to complete the work with perfection in very short duration. kindly give me a opportunity to join hands with you for this project thanking you