+ Reply to Thread
Results 1 to 1 of 1

Copy/Paste Issue

  1. #1
    Registered User
    Join Date
    06-13-2011
    Location
    Boulder, Colorado
    MS-Off Ver
    Excel 2010
    Posts
    61

    Copy/Paste Issue

    Hey Guys,

    I am trying to create a macro to help automate the data analysis process for my research. I have CSV files that are grouped in sections of 8 which all contain data which I need to consolidate and then average for further analysis. I've written the following code which effectively opens all 8 of my desired files with a pretty simple Do Loop. Ideally, I wanted all of the data to be copied directly to my worksheet titled "master" however due to continual formatting errors within Excel I have decided to create 8 different sheets which the data from each of my 8 files are copied and pasted. So far all of this is working just fine however when I try to copy each of these columns of data and paste them onto my "master" sheet nothing is being pasted. After a little trouble shooting I noticed that after all of the data is pasted to their respective sheets each of the columns containing data are still highlighted. I've tried activating individual sheets or even selecting individual cells but nothing seems to work. I've included my code below as well as my workbook to better illustrate my set up. Any helps is greatly appreciated thanks again.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Impartial Derivative; 06-06-2012 at 05:17 PM. Reason: I quickly found my error

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1