I have several cells in column B which I would like to copy across under all the columns on the worksheet automatically using a macro.
I currently have a macro which pastes data in from another workbook and the bottom twelve cells in column B are part of a template. I need these twelve cells copied under all the columns which are copied over automatically.
So if four columns are pasted into the worksheet then the twelve cells under column B are then copied under C,D, and E. The twelve cells contain formulas for handling the data in each column.
The twelve cells are B80 through B91. Copied over they will be pasted into C80:C91, D80:D91,...etc.
I currently have a macro which pastes data in from another workbook and the bottom twelve cells in column B are part of a template. I need these twelve cells copied under all the columns which are copied over automatically.
So if four columns are pasted into the worksheet then the twelve cells under column B are then copied under C,D, and E. The twelve cells contain formulas for handling the data in each column.
The twelve cells are B80 through B91. Copied over they will be pasted into C80:C91, D80:D91,...etc.