I download a large file of data regularly from the internet that comes in a .csv

Question

I download a large file of data regularly from the internet that comes in a .csv file. I have created an excel template that contains some but not all of the data. It also integrates a few equations to make life a bit easier. I want to find a way to get the .csv file information into the exxcel template without having to manually enter it in. My knowledge of coding for excel is very little. Is there an eaasy way to do this? I currently have a mac but I want this to be usable for some colleagues on their PC's. Thankss!!!!   

Explanation / Answer

The only way to do this is with a VBA macro. The way the data is laid out and the result you want determines the complexity of the code. You can try recording a macro when moving the data manually.   

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.