Need a Macro for the following problem in Excel:
I have a data of 7x6 in an excel sheet as shown below
A B C D E F G
Ref1 Ref2 Ref3 Ref4 Ref5 Ref6 Ref7
1 1 4 7 6 3
2 3 5 2 3 4
3 5 1 3 8 8
4 7 4 9 5 2
5 6 2 4 2 9
I would like the data to shift as follows based on a number in a cell somewhere that I can change from time to time.
I would like to insert empty cells (2 columns) before cell C3 through C4 by selecting these cell in the Column C
This should shift the data in the desired cells to the right
Can someone help?
I have a data of 7x6 in an excel sheet as shown below
A B C D E F G
Ref1 Ref2 Ref3 Ref4 Ref5 Ref6 Ref7
1 1 4 7 6 3
2 3 5 2 3 4
3 5 1 3 8 8
4 7 4 9 5 2
5 6 2 4 2 9
I would like the data to shift as follows based on a number in a cell somewhere that I can change from time to time.
I would like to insert empty cells (2 columns) before cell C3 through C4 by selecting these cell in the Column C
This should shift the data in the desired cells to the right
Can someone help?
