Please help me with this scenario
I would like to create a macro that will automatically insert a two rows and a page number such "1","2" after 50
Please help me with this scenario
I would like to create a macro that will automatically insert a two rows and a page number such "1","2" after 50
So, I would like to create this scenario:
suppose column Number is on "A", Amount is on "B" and text "1" (as page number) is to be added on column "C".
after Number = 50, i would like to insert 2 rows and text "1" in 2nd new row on column C.
IMPORTANT: if the Number jumping , for example after 96 immediately 101, then insert 6 blank rows ( 4 + 2 rows), pretending 97-100 is exist.
It will be like this:
No Amount
1
2
3
..
50
1
51
52
53
...
96
2
101
102
103
Sorry, correction. I can't use "edit post" feature (it is error/unresponding) So I use quick reply.
It should be like this:
Number Amount
1 1500
2 1700
3 1800
.. ..
50 1800
[blank row]
[blank column] [blank column] 1
51 1800
52 2100
53 2200
... ..
96 3200
[blank row]
[blank row]
[blank row]
[blank row]
[blank row]
[blank column] [blank column] 2
101 1200
102 1800
103 1800
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks