Hey everyone,
I am trying to copy weekly data from .csv files into a main template which analyzes the data and makes scatter plots. Right now I have been doing it with copy and paste but I am trying to make it so i can run a macro that will open the documents and gather the data and paste the data in a specific location on a specific worksheet in the template. The location that the data is placed in is critical because of the scatter plots. i tried the recorder modified it and I came up with this:
It gets stuck at the bolded part. Any ideas??
Bookmarks