+ Reply to Thread
Results 1 to 5 of 5

Cycle through Worksheets In Workbook & Copy Data to Another Workbook

  1. #1
    Registered User
    Join Date
    12-18-2012
    Location
    Miami, Florida
    MS-Off Ver
    Excel 2007
    Posts
    61

    Cycle through Worksheets In Workbook & Copy Data to Another Workbook

    Hello,

    The attached file contains details of what I need to do.

    I need to copy data (highlighted areas) from 300+ worksheets in LineData1.xls workbook to Cycle Worksheets & Copy Data workbook to CopyTo 1 worksheets under the applicable fields.

    Not sure how to do this and ask for your help.

    DeannaCycle Worksheets & Copy Data.xlsx

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Cycle through Worksheets In Workbook & Copy Data to Another Workbook

    http://www.rondebruin.nl/tips.htm
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    12-18-2012
    Location
    Miami, Florida
    MS-Off Ver
    Excel 2007
    Posts
    61

    Re: Cycle through Worksheets In Workbook & Copy Data to Another Workbook

    Hello,

    Non of those subroutines fit my situation.

    Per the highlighted areas in the attached worksheet, I need to copy those areas (highlighted) that are the same for over 300+ sheets in workbook Line1Data file to a Table style worksheet named Cycle Worksheets & Copy Data.xls under Tab, CopyTo 1.

    What I need help with is a subroutine that will Loop through 300+ sheets in a workbook and copy those highlighted areas. The subroutine would need to stay on that sheet until it has copied all 3 Product Numbers, which the subroutine may repeat copying the same data as some data will be the same for the three Product Numbers (ie Line; Shift No.; and Date).

    Not sure how to write such a procedure and need help.

  4. #4
    Valued Forum Contributor
    Join Date
    05-20-2013
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2013
    Posts
    941

    Re: Cycle through Worksheets In Workbook & Copy Data to Another Workbook

    You left out a lot of necessary info...

    Anyway, you don't necessarily need VBA to do this. See attached example files. Place both in the same directory, and open both at the same time. I used a five sheet example, but for more sheets all you have to do fill down the formulas (you always have to select previous three "banded" rows in the fill down, the helper column will clue you in to which). If you don't need linked info, after linked in, do a Save and Save As, then copy and paste values in place in the copy file.
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Cycle through Worksheets In Workbook & Copy Data to Another Workbook

    Thread solved, but it would be kind indicate how, thank those who helped you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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