add rows to table

  1. J

    Create Multiple Rows based on Years

    I have an Excel file that has the following columns. I need to have each Fitment Year listed as a single row. Is there a way to create a Macro that would look at the fitment years cell and then duplicate the row for each year? This is an ongoing macro that I will have to run each month against...
  2. H

    Auto-filling and other cells and inserting blank row when new data entered

    Hi I have a really important issue in a data spreadsheet of mine. I have seen various posts asking related questions but none that have really addressed what I need to accomplish. I have a worksheet (attached) in which I have a set of data (historical returns of 2 things). The month is listed...
    • hgeek23
    • Thread
    • add rows to table auto-fill auto-populate excel macro
    • Replies: 2
    • Forum: Excel Questions
  3. A

    Macro required to add new row at bottom of table

    Hi - many thanks to anyone who can help with this! I need to write a macro to add a new row at the bottom of a table, whilst at the same time copying down a selection of the row above it. I am able to write a macro to add a new row in at a specific point and fill down the required section but...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    • Started by Unexpc
    • Replies: 39
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
  • IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
    • Started by IDRIS86
    • Replies: 25
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    • Started by DEllis
    • Replies: 21
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top