Results 1 to 5 of 5

Insert formulas & copy them to variable size rows and columns

Threaded View

  1. #1
    Registered User
    Join Date
    07-31-2014
    Location
    Home
    MS-Off Ver
    Office 2010
    Posts
    21

    Insert formulas & copy them to variable size rows and columns

    I have being struggling with this over 4 hrs. Could you please help me?

    In "D3" I would need:
    1) Sum the values of the range "E3" to the last column to the right. The number of accounts changes every month.
    2) Copy the formula down to the last row (the last row changes every month)

    In “E3” I would need:
    1) Type in the formula that is in “E3”
    2) Copy that formula to the last row and last column (the last row and column varies month over month)

    Thank you in advance for your assistance,
    DPP
    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. Replies: 0
    Last Post: 03-17-2013, 05:10 AM
  2. Replies: 2
    Last Post: 12-18-2012, 05:22 AM
  3. Insert rows and copy formulas
    By amlal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2012, 02:53 PM
  4. [SOLVED] copy formulas to cells absolute rows and variable columns
    By Mark in forum Excel General
    Replies: 1
    Last Post: 01-30-2006, 06:20 PM
  5. [SOLVED] Copy/Insert rows with formulas
    By GregR in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-26-2005, 06:06 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