+ Reply to Thread
Results 1 to 2 of 2

Loop Program to Copy/Paste from One Sheet to Another

  1. #1
    Registered User
    Join Date
    08-13-2007
    Posts
    68

    Unhappy Loop Program to Copy/Paste from One Sheet to Another

    I have created an example file of what I am trying to do. As you can see the data is sorted going across the page and segmented by product. (This seems to be what is giving me the most trouble, but do to the complexity of other sheets asscociated to this document it is not feasible to rearrange)

    Many of the cells are blank, but some contain data. I am trying to create a looped prgram that will copy the data from each block (block meaning each month/product segment) and paste this data to a new worksheet in a vertical format. This would enable simple use of autofilter to sort products by load number.

    If anyone could give me a sample of how to call out the program I would be EXTREMELY grateful.

    Thanks in advance for any help.
    Attached Files Attached Files

  2. #2
    Forum Contributor boylejob's Avatar
    Join Date
    02-22-2007
    Location
    Forest City, NC
    MS-Off Ver
    2003
    Posts
    562
    smlaff01,

    Maybe something like this will get you going. You may need to make some adjustments to get the formating exactly how you want it. I have hard coded the number of months to cycle through, but that can be changed to find the last column used.

    Hopefully, this will at least get you started.

    Please Login or Register  to view this content.
    Sincerely,
    Jeff

+ 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