VBA to find a cell in the last row of a table and drag it down to the next row

  • Hi. In a worksheet ("SPCchartsdata") I have about a hundred tables that are used to produce charts. At the moment I am manually dragging the "Month" value from the last row in each table down to the row below in order to create a new row for the latest month. The dragging makes all the other columns automatically update. The first table "Table1" covers columns A to H. using Table1 as an example, is there a way you can show me how to automate the creation of the new row with a Macro please? Column B contains the month values. Many thanks for your help, Pete.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!