Results 1 to 8 of 8

Create Macro to Add Rows when the # of rows vary each month

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2017
    Location
    NC
    MS-Off Ver
    2010
    Posts
    9

    Create Macro to Add Rows when the # of rows vary each month

    Hi,

    I am trying to create a macro that will do some formatting and one of the things I would like to do is for the macro to add up several different columns. The thing is the number of rows will vary from month to month and I would like totals to be just underneath the last row. What's the best way to do this?

    I have attached a sample of my document.

    Thanks for the help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to extract Rows Colored with Yellow Fill and create a new sheet as per current month
    By prkhan56 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2016, 04:54 AM
  2. Macro to copy table from sheet1 to sheet2 (qty of rows may vary)
    By arkharova.s in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-18-2014, 03:54 AM
  3. macro to copy table from sheet1 to sheet2 (# of rows in table may vary everytime)
    By arkharova.s in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2014, 03:18 AM
  4. [SOLVED] VBA to create a chart when data can vary in column position and rows
    By MalibuLX3 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-21-2013, 11:21 AM
  5. [SOLVED] Macro To AutoSum Columns With Rows That Will Vary When The Report Is Run
    By Macro Fool in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-17-2012, 10:54 AM
  6. Replies: 2
    Last Post: 07-06-2012, 02:38 PM
  7. Using a macro to delete last 4 rows and last 2 columns which vary
    By Shirley Munro in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-01-2005, 12:05 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