VBA to parse a txt file into excel and format
Budget: $30 – $250 NZD
we have delimited txt file +- 400 rows by 12 columns (of invoice data) that we need VBA to
-fetch and drop into temp tab
-parse the rows into format tab ensuring alignments formats etc
attached is png of before and after
we do this allot and are looking to outsource these. you should budget 6-8 hours to do this well (4 hours will get it done but not tidy)
you need to be used to parsing txt files with vba
-fetch and drop into temp tab
-parse the rows into format tab ensuring alignments formats etc
attached is png of before and after
we do this allot and are looking to outsource these. you should budget 6-8 hours to do this well (4 hours will get it done but not tidy)
you need to be used to parsing txt files with vba