+ Reply to Thread
Results 1 to 2 of 2

Moving rows, counting, and deleting original row

  1. #1
    Registered User
    Join Date
    04-12-2007
    Location
    Nashville, TN
    MS-Off Ver
    2007
    Posts
    10

    Question Moving rows, counting, and deleting original row

    Here's what I'm needing:

    In column "S" of my worksheet I need:
    • look for "lock", "AD", "Group"
    • Move the row to another sheet named "Active_Directory"
    • Delete the Blank line where I just moved the data from
    • Count how many times this is done and store write the number to a different sheet called "Totals" as in the example below

    Begininning in cell A5:

    Active Directory 37

    Where 37 is the number of times it was found in the "S" column and moved to the "Active_Directory" sheet.

    Any help would be appreciated.

    Thank you.
    Last edited by arthurbr; 08-10-2010 at 12:03 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: Moving rows, counting, and deleting original row

    In sheet1 columns R,S will have these sample data(R1 to S8)

    hr hs
    1 a
    2 s
    3 lock
    4 f
    5 AD
    6 g
    7 Group

    T1 will have enry "ht"
    T2 will have formula
    =IF(OR(S2="lock",S2="AD",S2="Group"),"move","")
    copy T2 down.

    now copy entries in sheet1 to SHEET3

    ALSO YOU HAVE SOME ENTRIES IN COLUMN A IN ALL THESE EIGHT ROWS.

    If these conditions are satisfied try this macro "test". The second macro "undo" is to reverse the results of the macro "test"


    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

+ 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