new-ish excel user so apologies if answer is obvious!
I need to take a 140 column comma delimted file, import into Excel, assign new values to 30 of the columns based on a lookup (e.g. if column entry = Mr, replace with CG1254SFV), then export it again as a comma delimited file with "" marks around each value.
And I need to make this an automated procedure using a macro
Is this something I can do in Excel?
Any feedback greatly appreciated.
I need to take a 140 column comma delimted file, import into Excel, assign new values to 30 of the columns based on a lookup (e.g. if column entry = Mr, replace with CG1254SFV), then export it again as a comma delimited file with "" marks around each value.
And I need to make this an automated procedure using a macro
Is this something I can do in Excel?
Any feedback greatly appreciated.