Auto fill columns

Closed
namitasharma1512
Posts
3
Registration date
Thursday January 1, 2015
Status
Member
Last seen
January 10, 2015
- Jan 1, 2015 at 10:22 PM
Hi,

Just new to Excel.
I recorded a macro to paste column names in a formatted table and want the formula in first cell to be applied automatically. The formula is {=Table1[@[SALARY]:[SALARY]]*Table1[Column1]}. This works perfectly when I drag it horizontally. I want to avoid this dragging and want to do it with a macro.

PS:- The column names and number of columns to be pasted are variable, so range cannot be fixed