We have data that gets exported from our accounting system to excel. We need to add two buttons to this spreadsheet to do the following things:
1. Validate the data (IE, the lengths are correct, or the date is not blank, etc..)
2. Generate a TXT output file.
The output file basically strips down the DATA, places the data in the right order, Example 20090901 for date. This data is to be read by another system and the results have to be exact.
IF IT MAKES THE PROJECT ANY EASIER, please note that we already have the finished product, but we have it in two files and would like to integrate into one containing Sheet1 and Sheet2.
51 freelanceria on tarjonnut keskimäärin 58 $ tähän työhön
Hi, Very good command on xls macros, I will do this work for you, ready to start it immediately, interested to work with long term, daily available for communication.
I am a VBA expert. I have very good experience with VBA Excel/ Macros. I have completed many projects on GAF in this skill i will provide quick & professional service.