Need some work done? Post a Project Today
I have manual process of entering data from txt files into excel. What I basically need is a macro to be able to open the text files extract the data put the data in the correct columns. The actual calculation is done by formulas already on the actual excel file. So its just basic data entry macro to save time that I wish to create. The number of files are upto 10 small files, usually 3. Really the process takes no more then 20 minutes to do but will be good if can be automated. The macro will also need to do some basic arithmetic operations on the data also that is currently by hand. All documentation will be provided once I find someone with good VBA/EXCEL macro skills.