lordrummxx1
New Member
- Joined
- Mar 28, 2019
- Messages
- 6
A | B |
<tbody>
</tbody>
I'm trying to get a button to automatically copy the formulas and formatting of the Cells in Column A, to column B and then be able to press again to create a column C. I don't want the numbers in the cells to be copied, just the formulas and formatting.
EDIT:
Maybe its easier to explain this way. I can easily record a Macro copying the rows in column A into column B, but my problem comes if i want to build off that can have the macro create a column C off of column B and so on. I'm trying to track quarterly data and want to create a macro that, when pressed, will create a new column were new data can be entered, without having to manually drag over the previous column forward.
Last edited by a moderator: