Autofill formula across columns within excel table

[mrklmac]

Hi,

I have an excel table (ListObject), to which I am adding a column at the click of a button via a Macro.

The macro needs to also drag the formula form the last existent column into the new column. The formula references another column within the same table.

I am using autofill to drag along the formula into the new column, but it does not seem to be changing references. It keeps the references of the source cell (which is being used for autofill), so the value in the new column returns the same value as the existent one.

For example say there are 3 columns in Table1:
a) Column A - existent
b) Column B = Column A + 1
c) New column being autofilled onto - Column C should be equal to Column B + 1
BUT when using autofill, Column C is returning Column A + 1, same as source.

Does VBA autofill not work for cells that reference columns within a table?

Mark

[alansidman]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary. Additionally, if you have existing VBA Macro, be sure to include it for analysis.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[MarvinP]

Hi mrlkmac and welcome to the forum,

It sounds like you need to learn about Absolute vs Relative addressing. It is all about the dollar signs.

http://www.iwillteachyouexcel.com/ex...ve-references/

Alan is correct that we need to see a sample workbook to understand where those dollar signs go.