Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    La Jolla, CA
    Thanked 61 Times in 57 Posts

    Move data in Excel (2007)

    I posted this in the Excel group because it's for Excel, but maybe it's more appropriate here.

    Probably VB which I don't know...

    Spreadsheet has row 1 with headings.
    Column A is names
    Column B, C, etc. contain hours (integers).

    I need a macro (VB, I assume) that will do the following.

    When the total of any given row (cols B through whatever) is greater than or equal to 12,
    move this row to the bottom of the name list and blank out the numbers in the cell from col B on. The name in col A must remain.

    Thanks, in advance.

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Thanked 7 Times in 7 Posts

    Re: Move data in Excel (2007)

    The original post can be found at <post:=671,016>post 671,016</post:> in the Excel forum, please post any responses there.

    I will lock this thread - to keep all the discussion in one place.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts