Auto move the entire row if the date fall between certain date

  • Hi All,


    I have an problem in the excel, i would like to move up the entire row if the cell fall between the given date.
    For example,


    [TABLE="width: 500"]

    [tr]


    [td]

    OCT

    [/td]


    [td]

    Fruit Type

    [/td]


    [td]

    Expire date

    [/td]


    [/tr]


    [tr]


    [td]

    1

    [/td]


    [td]

    Watermelon

    [/td]


    [td]

    Oct 6

    [/td]


    [/tr]


    [tr]


    [td]

    2

    [/td]


    [td]

    Bread

    [/td]


    [td]

    Oct 18

    [/td]


    [/tr]


    [tr]


    [td]

    3

    [/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    1

    [/td]


    [td]

    Apple

    [/td]


    [td]

    Oct 8

    [/td]


    [/tr]


    [tr]


    [td]

    2

    [/td]


    [td]

    Orange

    [/td]


    [td]

    Nov 9

    [/td]


    [/tr]


    [tr]


    [td]

    3

    [/td]


    [td]

    Grape

    [/td]


    [td]

    April 12

    [/td]


    [/tr]


    [/TABLE]



    I want to move up the entire row as all the expire date fall on Oct whenever input every item which expire on oct
    kindly help and assist .... PLEASE ...
    Appreciated in advance.


    Thanks you very very very much

  • Re: Auto move the entire row if the date fall between certain date


    You need to explain this a little more clearly.


    If there's a language barrier then make up a sample workbook with 2 lists with before and after examples, then upload that to the thread.


    [sw]*[/sw]

  • Re: Auto move the entire row if the date fall between certain date


    Sorry, it's not at all clear what you want.


    Yes, you can list movies that are showing in August and September no problem but that will only for those specific dates - what happens in October, November and later?


    Perhaps if you try to explain how this is used. Is it to list scheduled showings for the current and previous month? It is an input sheet where the user types in the film name & showing dates and it is then moved to the correct period...?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!