+ Reply to Thread
Results 1 to 3 of 3

Do While Loop

  1. #1
    Registered User
    Join Date
    03-10-2013
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2007
    Posts
    26

    Do While Loop

    Hello,

    I have code that I want to check each line looking for the word "UNMET" in the FE Column starting at row 2 and when found copy and paste section of that over to a pre-modified template on the result worksheet. So far with help of this forum I was able to get it to do some of it but for some reason it's not checking each row and not copying and pasting say for instance row two and three section and making a new template, row nine and ten and making a new template ect, ect. Also if possible their sub sections to each for instance row 4,5,6,7,8 ect, ect to be added to the template section if needed by having a input box pop up and ask "Are there any additional lines needed to be added to that section and if so copy and paste those section to the template. Please see attachment. I know the second part seems very difficult and I can't imagine how to do it, but I know that this forum loves a challenge and can solve anything. Thank you in advance.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Do While Loop

    Can you please upload the file directly? I am having an issue with winzip on my system.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    03-10-2013
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Do While Loop

    Hi arlu1201

    Thank you for taking the time to look at my macro. I attached the file as requested. Thanks again.

+ 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