Hi all,
I'm stuck with a last bit of my sheet that needs a macro.
I thought it would be easy, but it seems harder than expected....
In cell B2 I have a number; when I increase or decrease that number, I would like all the entries from D5 til J5 and all rows below, to be cut and pasted accordingly by the number of rows of the figure that I have increased or decreased.
So for example on the picture below,
in B2 I have "3"
- If I change this figure to "4", range D5:J8 , should be cut and paste one row lower, hence in row 6.
- If I change this fugure to "2", range D5:J8, should be cut and paste one row higher, hence in row 4.
Rules for the range
- The row for the start of the range is determined by the fact that there's value in column B (nr of suppliers), below the figure that I have just changed. (In the example, if I change cell B2, first figure to be found in column B is on row 5).
- The row for the end of the range is 100 rows more.
- Columns D to J.
Any ideas for the macro?
Thanks a lot!
Help is much much appreciated!
I'm stuck with a last bit of my sheet that needs a macro.
I thought it would be easy, but it seems harder than expected....
In cell B2 I have a number; when I increase or decrease that number, I would like all the entries from D5 til J5 and all rows below, to be cut and pasted accordingly by the number of rows of the figure that I have increased or decreased.
So for example on the picture below,
in B2 I have "3"
- If I change this figure to "4", range D5:J8 , should be cut and paste one row lower, hence in row 6.
- If I change this fugure to "2", range D5:J8, should be cut and paste one row higher, hence in row 4.
Rules for the range
- The row for the start of the range is determined by the fact that there's value in column B (nr of suppliers), below the figure that I have just changed. (In the example, if I change cell B2, first figure to be found in column B is on row 5).
- The row for the end of the range is 100 rows more.
- Columns D to J.
Any ideas for the macro?
Thanks a lot!
Help is much much appreciated!