Hello,
I am totally new to VBA but I have been given a huge project that involves collecting data from across the plant floor and putting that data into workbooks for other engineers to analyze. It will ultimately have to email the appropriate engineers data if assemblies that fall under their jurisdiction fall out of spec. I am setting up the prototype now and wondering how to build a simple but robust script that I can easily configure in the future. The system on the plant floor generates CSV files.
Here is my question:
How can VBA copy the last row of data from the plant floor workbook (X166.csv), transpose and paste that data in an empty column at the end of my data in the second workbook (Monitor Data Analyzer.xlsm)?

I know that this must be easy but from my current perspective, I get tripped up in the syntax and structure. If you can help me understand this, I'll be truly grateful.
-jlc-