ashupuneet
11-10-2016, 05:01 AM
Hi
I need help for VBA code. first it copy down formula's from 1st row (From column K to AA) to next row and then remove formulas from 1st row and paste it as a value in 1st row from where it copied. This will continue till it find a blank cell in J column.
Next time again it start from row (column K to AA) where previously stopped.
Formulas are in from column K to AA.
J
K
L
M
N
O
P
Q
R
S
till AA
NO
Crop
Time
day_1st
1st_time
day_2nd
2nd_time
day_3rd
3rd_time
Balance Capacity
4
CUL
0.2
4
0.2
8
0.07
0
0.07
27.47
From this row formula need to copy down to below row and then remove formula from this row followed by paste value.
4
this row need to have formulas copied down from above row
4
4
Thanks
I need help for VBA code. first it copy down formula's from 1st row (From column K to AA) to next row and then remove formulas from 1st row and paste it as a value in 1st row from where it copied. This will continue till it find a blank cell in J column.
Next time again it start from row (column K to AA) where previously stopped.
Formulas are in from column K to AA.
J
K
L
M
N
O
P
Q
R
S
till AA
NO
Crop
Time
day_1st
1st_time
day_2nd
2nd_time
day_3rd
3rd_time
Balance Capacity
4
CUL
0.2
4
0.2
8
0.07
0
0.07
27.47
From this row formula need to copy down to below row and then remove formula from this row followed by paste value.
4
this row need to have formulas copied down from above row
4
4
Thanks