Results 1 to 7 of 7

Copy a row from 3000 excel files stored in a folder and paste it in a new workbook

Threaded View

hubertus Copy a row from 3000 excel... 07-27-2009, 07:47 AM
Phil_V Re: Copy a row from 3000... 07-27-2009, 08:31 AM
hubertus Re: Copy a row from 3000... 07-27-2009, 08:49 AM
Phil_V Re: Copy a row from 3000... 07-27-2009, 09:13 AM
hubertus Re: Copy a row from 3000... 07-27-2009, 09:34 AM
hubertus Re: Copy a row from 3000... 07-28-2009, 10:13 AM
Phil_V Re: Copy a row from 3000... 07-28-2009, 10:34 AM
  1. #1
    Registered User
    Join Date
    07-27-2009
    Location
    Bratislava, Slovakia
    MS-Off Ver
    Excel 2003
    Posts
    4

    Question Copy a row from 3000 excel files stored in a folder and paste it in a new workbook

    Hi,

    Here's my situation:

    I have 3000 workbooks in a folder.
    Each has a worksheet named "Sheet1"
    There are 13 colums and 2 rows of data in Sheet1.

    I need to copy the second row from all excel files stored in the folder and
    paste them into a blank workbook.

    I really do not know how to proceed with this. I have basic VBA knowledge.

    Thank you very much for any advice, I will greatly appreciate it.
    Last edited by hubertus; 07-28-2009 at 10:14 AM.

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