harveya915
Board Regular
- Joined
- Sep 4, 2015
- Messages
- 141
A bit of a novice here. I usually try to find my answers first before posting, although I kinda found an answer on a thread here, when asking for help I was told to start a new thread. So...
I have a sheet with 5 columns (C-G). I need to insert 5 columns with the same formatting and formulas (only columns C and G have formulas) into columns C-G, making the previous group of columns mover over on to I-M. Leaving column H as a blank column to distinguish where one group of column ends and the other begin.
Each group of columns will have the same headings/titles. This will be Row 3.
On Row 2 above each group of columns i merged the cells so that a date can be input.
I created a button on a UserForm so that when it is clicked, it performs the above operation. Every time it is clicked it inserts 5 new columns as described above.
Any help would be greatly appreciated.
I have a sheet with 5 columns (C-G). I need to insert 5 columns with the same formatting and formulas (only columns C and G have formulas) into columns C-G, making the previous group of columns mover over on to I-M. Leaving column H as a blank column to distinguish where one group of column ends and the other begin.
Each group of columns will have the same headings/titles. This will be Row 3.
On Row 2 above each group of columns i merged the cells so that a date can be input.
I created a button on a UserForm so that when it is clicked, it performs the above operation. Every time it is clicked it inserts 5 new columns as described above.
Any help would be greatly appreciated.