+ Reply to Thread
Results 1 to 1 of 1

Creating group of rows automatically while keeping formatting in tact

  1. #1
    Registered User
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    99

    Question Creating group of rows automatically while keeping formatting in tact

    We are currently using this form for rating training.

    We are adding a conditional formatting to Cells K35:N39 to change it yellow based on variables.

    But we would like to see if we can change the worksheet so we do not have to have 40+ groups of rows in the spread sheet and auto create the group such as A32 through N41 as needed.

    See sheet WOULD LIKE TO CHANGE TO for problem and details.


    I would like to be able to add a set of rows to be filled in by the user while keeping the same formatting and averaging.

    So once cells A32:N41 is complete I would like to have it create a new group of cells bellow it.

    The kicker is cells E33:E39 and Cells J33:J39 are averaged in their respective cells in rows 12-18.

    Also the check box in cell N34 is adds 1 to Cell I9 and is summed up by each subsequent Check box in subsequent cells created

    I know how to create one row automatically with the same formatting.

    I just can’t figure out how to create multiple rows with the calculations in cells F12:F18 and M12:M18 intact.

    Also I cannot get the check boxes to come across.

    The only Check box with a formula attached is in N34 the rest only indicate a category.

    Is this possible?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automatically keeping rows sorted in alphabetical order
    By damiensmith212 in forum Excel General
    Replies: 8
    Last Post: 04-24-2009, 06:50 PM
  2. Remove duplicates based while keeping other rows in tact.
    By rivertonstudios in forum Excel General
    Replies: 2
    Last Post: 02-22-2009, 03:47 PM
  3. Delete Entire Row, but keeping the Formula in tact
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-26-2008, 01:34 PM
  4. How to sort worksheet data keeping rows in tact
    By lea147 in forum Excel General
    Replies: 3
    Last Post: 05-10-2008, 05:43 PM
  5. [SOLVED] sorting (alphabetizing) while keeping data in tact.
    By 5string in forum Excel General
    Replies: 2
    Last Post: 10-10-2005, 12:05 AM

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