In answer to your question, it can! It will require the use of Python to code the back end, and that of course requires some minor setup, and use of some programming to access the appropriate fields. Essentially the code goes something like this:
getThisWorkbook.thisCell = thisValue
thisValue = thatOtherWorkbookCellValue
You can see the following link for the exact instructions and codes for the setup and implementation!
Please let me know if you need further assistance! :)
You can upload those, I unfortunately have other things to attend to, but I can easily step out of the way and let our other guys here take care of that for you! :)
Hi there Mark and welcome
Sorry about the delay, it appears your previous expert has left the conversation.
I will help you with this.
I looked through the files and your going to need to also use Microsoft Access for this (as an inbetween, Excel will be the final product). Do you have this installed on the computer?
and to confirm, you want the Txt file to be put into Excel correct? Just match the fields.
yes, there is one issue with the text file but I can overcome it in Access.
Basically Access imports it and spits out the Excel file
It runs on Windows Mark, if the same version of Access is on a mac it will run on that as well.