+ Reply to Thread
Results 1 to 2 of 2

Automate calculations when adding new column of data

  1. 01-18-2022, 05:42 PM #1
    holdenmcgroin
    holdenmcgroin is offline
    Registered User
    Join Date
    01-18-2022
    Location
    Los Angeles, California
    MS-Off Ver
    2019
    Posts
    5

    Exclamation Automate calculations when adding new column of data

    Regularly, I get a excel file with P&L monthly actuals. I create 7-8 columns at the end of the spreadsheet that does calculations based on the data that is provided. Is it possible to create a macro that will calculate the data set when I copy and paste new columns?
    Reply With QuoteRegister To Reply
  2. 01-19-2022, 02:53 PM #2
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Automate calculations when adding new column of data

    @holdenmcgroin

    Welcome to the forum.

    Please complete your user profile. This informs us what version of Excel we are writing solution for, location informs us of regional differences to consider.
    Dave
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automate calculations on a database
    By Hb47 in forum Excel General
    Replies: 4
    Last Post: 11-12-2016, 02:10 AM
  2. [SOLVED] Automate rowing block calculations
    By plumberef in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-14-2015, 02:12 AM
  3. Using VBA to automate a CMS scriipt - adding more data to bottom of sheet
    By elliotencore in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-27-2013, 04:50 AM
  4. Automate bonus payment calculations
    By Excelbeginner1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-22-2013, 08:31 PM
  5. importing data:Can I automate this process to keep adding data
    By veeru in forum Excel General
    Replies: 2
    Last Post: 03-28-2008, 07:08 AM
  6. Automate row deletion after adding data
    By sbdivemaster1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2005, 12:02 AM
  7. Automate row deletion after adding data
    By sbdivemaster1 in forum Excel General
    Replies: 0
    Last Post: 03-16-2005, 11:58 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1