+ Reply to Thread
Results 1 to 3 of 3

Open each file in a folder and test and copy certain rows

  1. #1
    Registered User
    Join Date
    11-21-2013
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Open each file in a folder and test and copy certain rows

    Hi experts,

    I am stuck on my macro and hoping someone can shed some light on getting my macro to work.
    I am trying to build a macro that opens each file in a folder and copy a whole row that has certain data in a certain column.
    For instance, when I open first file and if there is a number 148 in its column J, I would like to copy that entire row to my macro sheet.
    and I would like to repeat the process until the very last excel file in the folder.
    Below is my code.

    Thanks much in advance,

    Please Login or Register  to view this content.
    Last edited by jungjiyungg; 05-28-2014 at 06:08 PM.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Open each file in a folder and test and copy certain rows

    Where is it hitting a roadblock?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    11-21-2013
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Open each file in a folder and test and copy certain rows

    I figured it out..
    I messed up on my loop and copy and pasting row area.

    Thanks much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macros Open folder, copy, paste and close the folder
    By hahahahahahaha in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2013, 05:03 PM
  2. [SOLVED] VBA Code open files in folder, copy text to workbook-Next time folder opened copy only new
    By Bikeman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2013, 07:59 PM
  3. [SOLVED] Open specific folder, select file to open and copy then paste
    By Kranky in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-22-2012, 12:14 AM
  4. command button- open folder and copy data from .csv file
    By karo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-01-2012, 08:17 AM
  5. Open file in folder and copy data to another file
    By Sharp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2008, 08:21 AM

Tags for this Thread

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