+ Reply to Thread
Results 1 to 7 of 7

Find,copy and create sheet

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    05-16-2011
    Location
    Philippines
    MS-Off Ver
    Excel 365/Excel 2016
    Posts
    315

    Find,copy and create sheet

    Hi to all, I need help please. Kindly download and see workbook first so you can know my problem, I need to find the "Account" Number in "Raw" Tab, list of Account number are in "Find & Separate" tab, I just set 3 account number only for my example but in reality I have to separate 400 account number. On Raw tab each account number has details below of them before the next account number. Each account number must copy and create tab and the name will be the Account number itself. Can i know how to create a VBA macro code for it? so I don't have to manual 400 account number,for clarification kindly send reply on this thread, Thank you so much in advance to those who are willing to help.

    PS: The occupied column per account are not fixed(see Raw tab), if see the workbook some account occupied only column H or I .
    Attached Files Attached Files
    Last edited by emina002; 06-14-2013 at 05:57 AM.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Find,copy and create sheet

    hi so i understand the problem better
    are you having issues separating the account numbers at all?

    you only need a macro to create a new sheet for each number in the find and seperate tab?
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Contributor
    Join Date
    05-16-2011
    Location
    Philippines
    MS-Off Ver
    Excel 365/Excel 2016
    Posts
    315

    Re: Find,copy and create sheet

    Quote Originally Posted by humdingaling View Post
    hi so i understand the problem better
    are you having issues separating the account numbers at all?

    you only need a macro to create a new sheet for each number in the find and seperate tab?

    Hi to make it clear on your question, I just need to find the number listed on "Find & Separate" tab on "Raw" tab,if the number has been found it will copy the details below along with account number and paste it on a new create tab, the tab name would be the account number, Yes I need a macro that meet the requirements. I don't know if I have to complicate things because of the account number listed on "Find & Separate" tab, I just attach sample output on what would be the content of 1 account number. Kindly see. Thank you

  4. #4
    Forum Contributor
    Join Date
    05-16-2011
    Location
    Philippines
    MS-Off Ver
    Excel 365/Excel 2016
    Posts
    315

    Re: Find,copy and create sheet

    Here is the update sample workbook.
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Find,copy and create sheet

    ok here is what i got

    i copied RAW into VBA for debugging purposes

    there will be issue if account numbers are duplicated but i assume each account is unique so this should not be a problem
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    05-16-2011
    Location
    Philippines
    MS-Off Ver
    Excel 365/Excel 2016
    Posts
    315

    Re: Find,copy and create sheet

    It really works. thanks a lot

  7. #7
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Find,copy and create sheet

    glad to help
    thanks for rep

+ 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