New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Auto populate Formula in Column when inserting new row

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Auto populate Formula in Column when inserting new row

Postby lreaton » Wed Feb 03, 2016 11:46 am

I am working on a project where i am using the IF Function in the last row to calculate information based on two other columns and I i need the end user to be able to insert rows to add additional information and want this IF statement to Auto populate in the Column in the newly inserted row .

How do I do this?
  • 0

lreaton
Rookie
 
Posts: 1
Joined: Feb 3, 2016
Reputation: 0
Excel Version: 2007

Re: Auto populate Formula in Column when inserting new row

Postby pecoflyer » Thu Feb 04, 2016 2:45 am

Hi and welcome to the board.
Just select your range then Insert Table and follow the wizard
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 121 guests