Closed Thread
Results 1 to 2 of 2

Adding rows with text formulas and formatting

  1. #1
    Registered User
    Join Date
    10-26-2015
    Location
    Milwaukee
    MS-Off Ver
    2010/2013
    Posts
    22

    Adding rows with text formulas and formatting

    Ok so I have a workout tracking sheet for multiple workouts one after another on the same sheet. Meaning the tracking sheet for workout 1 goes from row 9 to row 100 and workout 2 starts on 102 and goes to 200 etc.

    There is a drop down box that has a macro that shows/hides the correct range for each workout.

    I want to be able to add days indefinitely to the end of a tracking sheet. For example if the user wanted to add a day to the workout 1 tracking log then they would click a button and it would add the appropriate text formatting and formulas as necessary.

    The macro would also adjust the ranges of the drop down box so that the range of workout 1 is modified when new days are added to the log.

    I am currently on my phone but can post a dummy document later.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,942

    Re: Adding rows with text formulas and formatting

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

    http://www.excelforum.com/excel-gene...ormatting.html
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding new row, auto-copying formulas and maintaining formatting
    By jerrydiaz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-30-2014, 09:32 AM
  2. [SOLVED] Conditional Formatting (Adding text and cell formatting)
    By fredjones in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-26-2012, 04:15 AM
  3. Replies: 4
    Last Post: 01-19-2012, 06:56 AM
  4. Using subtotals and adding formatting / formulas
    By kmlloyd in forum Excel General
    Replies: 1
    Last Post: 12-02-2009, 05:15 PM
  5. Adding rows whilst retaining formulas and formatting
    By Forbez in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-25-2008, 11:02 AM
  6. Adding Rows to Formulas
    By teq in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-29-2007, 03:02 PM
  7. Adding rows in between formulas
    By Mary in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-21-2006, 12:55 PM

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