+ Reply to Thread
Results 1 to 2 of 2

Header, Length, Split, New Sheet

  1. 01-16-2013, 06:45 AM #1
    ssakthish
    ssakthish is offline
    Registered User
    Join Date
    09-18-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    11

    Header, Length, Split, New Sheet

    Hi All,

    Please help me with the below Query.

    I cannot Attach file. I will just paste the data how the macro workbook be.


    Reference Table
    Technical Name Character Length

    ORG_CRMID 10
    ORG_DUNS 9
    ORG_ID_TYPE 6
    ORG_ID_NUMBER 60

    ------------------------------------------------------------------------------------------------
    Requirement:

    in Excel Column A (Header) ORG_CRMID
    In Excel Column B (Header) ORG_DUNS
    In Excel Column C (Header) ORG_ID_TYPE
    In Excel Column D (Header) ORD_ID_NUMBER

    I want a macro workbook with above data provided, wherein if the length exceeds (refer Reference Table), the entire row should be moved to sheet2.


    In the input file I provide Only ORG_CRMID, ORG_DUNS & ORG_ID_NUMBER, where ever the header matches, it should read for those column and if cell length exceeds, then the row should be moved to sheet2.

    Regards,
    Sakthish.
    Reply With QuoteRegister To Reply
  2. 01-16-2013, 09:13 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,613

    Re: Header, Length, Split, New Sheet

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.



    We only help on certain problems not to create a worksheet for you..
    You should start first then if you encounter a problem on the worksheet it's the the time to ask a question to fellow members.
    Thanks.
    Ben Van Johnson
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1