Copy Column Solution

I made this Python script that I think was decently written. It copies designated column values associated with a key value (ie. GL #s), finds a matching key value on a second spreadsheet, then pastes the copied column values to designated columns on the second spreadsheet.

This Python code will be very practical in my line of work. For example, on a monthly basis we move actual data extracted as an Excel file from our database housed on FleetNet to our team's Excel files. With the formatting we use in our spreadsheets, it works better than using VLOOKUP. It also speeds up the Excel files performance.

The amount of time spent on this was about ~6 hours. The amount of time saved using this tool quickly exceeded 6 hours. The other value of this automation is the data being entered into the Excel file is as accurate as the data being given to the Python script. Less time has to be spent on doing the work and less time has to be spent reviewing the accuracy.

This is a link to a OneDrive folder where you can see the Python script titled, CoPy SprydShyts.

If you feel like looking at it and giving any suggestions, let me know, I'm at Nicholas.A.Sagan@gmail.com.