+ Reply to Thread
Results 1 to 3 of 3

Command button to insert row on multiple worksheets

  1. #1
    Registered User
    Join Date
    03-05-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    10

    Command button to insert row on multiple worksheets

    I require a command button that will ask me to enter a 'client code' and 'client name', and insert this information in a new row. Client code will be shown in column a and client name shown in column b. I need this new row to be inserted in alphabetical order with other existing rows as well as copy the formulas and conditional formatting on all related cells within that inserted row.

    On a another workbook I require the same as above, but with the addition of inserting the row on multiple worksheets.

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Command button to insert row on multiple worksheets

    pl attach the dumy file with before and after format.

  3. #3
    Registered User
    Join Date
    03-05-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Command button to insert row on multiple worksheets

    Not required
    Last edited by Hobsons; 03-26-2013 at 12:29 PM. Reason: Not required

+ 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