Auto-Fill Excel Columns

Closed
namitasharma1512
Posts
3
Registration date
Thursday January 1, 2015
Status
Member
Last seen
January 10, 2015
- Jan 3, 2015 at 03:34 AM
Hello friends,


I am new to Excel. Got a problem and request if anyone has a solution to this.

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. May I request if someone can guide me.

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