Results 1 to 6 of 6

Excel VBA code required to re-arrange the data based on Column condition

Threaded View

mchilapur Excel VBA code required to... 07-28-2015, 02:00 AM
zbor Re: Is it possible to do... 07-28-2015, 02:08 AM
mchilapur Re: Excel VBA code required... 07-28-2015, 02:24 AM
zbor Re: Excel VBA code required... 07-28-2015, 02:29 AM
nilem Re: Excel VBA code required... 07-28-2015, 02:30 AM
mchilapur Re: Excel VBA code required... 07-28-2015, 03:48 AM
  1. #1
    Forum Contributor
    Join Date
    09-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    275

    Lightbulb Excel VBA code required to re-arrange the data based on Column condition

    Dear all,
    Please review attached file.

    The data below "Scenario" is my present data and "Output Required" is something what i am looking for...

    Process (Refer "Scenario" data):
    1) If any of the Row "Type" is "O", then data available in 'commodity' column must be move to next upper "R" type column under "Col2" cell
    2) After moved, "O" type row has to be deleted.

    Is it possible to do..?

    Please help.
    Attached Files Attached Files
    Last edited by mchilapur; 07-28-2015 at 02:23 AM.

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