Hi
I need vba code help, with inserting row with prefix value with below functions
excel sheet attached or reference.
I have excel with sheet1
Sheet1 have some value in column A & B
wants output in-column C (Row 1 to 6) print some text mentioned in excel redcolour
Row 7 value comes from Sheet1 A1 with prefix "pick"
Row 8 value comes form sheet1 B1 with prefix "pick"
row 9 value comes from sheet1 B1 with prefix "prepopup"
row 10 print pop Next
Row 11 value comes from Sheet1 A2 with prefix "pick"
Row 12 value comes form sheet1 B2 with prefix "pick"
row 13 value comes from sheet1 B2 with prefix "prepopup"
row 10 print pop Next
its function should repeat entire column A &B row count.
I need vba code help, with inserting row with prefix value with below functions
excel sheet attached or reference.
I have excel with sheet1
Sheet1 have some value in column A & B
wants output in-column C (Row 1 to 6) print some text mentioned in excel redcolour
Row 7 value comes from Sheet1 A1 with prefix "pick"
Row 8 value comes form sheet1 B1 with prefix "pick"
row 9 value comes from sheet1 B1 with prefix "prepopup"
row 10 print pop Next
Row 11 value comes from Sheet1 A2 with prefix "pick"
Row 12 value comes form sheet1 B2 with prefix "pick"
row 13 value comes from sheet1 B2 with prefix "prepopup"
row 10 print pop Next
its function should repeat entire column A &B row count.
Macro_netlsit.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | (-2104.015 606.460) | (-16774.200 -4319.840) | setwindow pcb | Red text print code its self | ||
2 | (-2152.946 578.976) | (-17733.480 -12254.210) | trapsize 44051 | Red text print code its self | ||
3 | (-2055.084 633.943) | (-14237.800 -6693.650) | net logic | Red text print code its self | ||
4 | (-2006.154 551.493) | (-14790.610 -3742.660) | setwindow form.find | Red text print code its self | ||
5 | (-2055.084 524.009) | (-14790.600 -3214.250) | FORM find pins YES | Red text print code its self | ||
6 | (-2055.084 578.976) | (-14774.350 -1710.280) | setwindow pcb | Red text print code its self | ||
7 | (-1859.362 578.976) | (-14241.870 -4726.330) | pick (-831.819 -1635.866) | Red text print code its self next blue colour value call from sheet1 A1 | ||
8 | (-1957.223 578.976) | (-14278.450 -4271.070) | pick (-15724.520 -14702.760) | Red text print code its self next blue colour value call from sheet1 B1 | ||
9 | (-1957.223 524.009) | (-14286.580 -3263.010) | prepopup (-15724.520 -14702.760) | Red text print code its self next blue colour value call from sheet1 B1 | ||
10 | (-1810.431 496.526) | (-16721.370 -10725.880) | pop Next | Red text print code its self | ||
11 | (-1810.431 441.559) | (-16160.430 -10685.230) | pick (-880.749 -1663.349) | Red text print code its self next blue colour value call from sheet1 A2 | ||
12 | (-1614.709 496.526) | (-14262.200 -10254.370) | pick (-15749.850 -14305.920) | Red text print code its self next blue colour value call from sheet1 B2 | ||
13 | (-1614.709 441.559) | (-13205.370 -10221.840) | prepopup (-15749.850 -14305.920) | Red text print code its self next blue colour value call from sheet1 B2 | ||
14 | (-1663.639 469.042) | (-14672.740 -12254.210) | pop Next | Red text print code its self | ||
15 | (-1712.570 496.526) | (-15274.320 -12725.720) | pick (-929.680 -1635.866) | |||
16 | (-1712.570 441.559) | (-16201.080 -13180.970) | pick (-15673.860 -13740.210) | |||
17 | (-1761.501 469.042) | (-16770.140 -13668.740) | prepopup (-15673.860 -13740.210) | |||
18 | (-1810.431 551.493) | (-12741.990 -198.200) | pop Next | |||
19 | (-1418.986 -551.493) | (-12229.830 -8335.800) | ||||
20 | (-1467.917 469.042) | (-12294.870 -8726.020) | ||||
21 | (-1467.917 -469.042) | (-12278.610 -7766.740) | ||||
22 | (-1516.848 496.526) | (-12181.050 -9278.820) | ||||
23 | (-1516.848 441.559) | (-12278.610 -9766.590) | ||||
24 | (-1516.848 -496.526) | (-11725.800 -9295.080) | ||||
25 | (-1565.778 524.009) | (-12229.830 -10303.140) | ||||
26 | (-1565.778 469.042) | (-12229.830 -10790.910) | ||||
27 | (-1516.848 -551.493) | (-11709.550 -8758.540) | ||||
28 | (-1565.778 -524.009) | (-11164.870 -8791.060) | ||||
29 | (-1614.709 -496.526) | (-10766.530 -8766.680) | ||||
30 | (-1663.639 -469.042) | (-10750.270 -8287.040) | ||||
31 | (-1712.570 -496.526) | (-10213.720 -8262.650) | ||||
32 | (-1761.501 -524.009) | (-10238.110 -7685.460) | ||||
33 | (-1810.431 -496.526) | (-10278.760 -6287.190) | ||||
34 | (-1859.362 -524.009) | (-10246.230 -5701.860) | ||||
35 | (-1957.223 -578.976) | (-11249.220 -4246.690) | ||||
36 | (-1908.293 -551.493) | (-11249.220 -3677.630) | ||||
37 | (-2104.015 -606.460) | (-10728.930 -3775.170) | ||||
38 | (-1908.293 -496.526) | (-11257.340 -3271.150) | ||||
39 | (-2055.084 -633.943) | (-10753.320 -3287.400) | ||||
40 | (-2055.084 -578.976) | (-10737.060 -2767.120) | ||||
41 | (-2104.015 -661.427) | (-10258.420 -9782.860) | ||||
42 | (-2006.154 -661.427) | (-10184.250 -3208.140) | ||||
43 | (-2006.154 -606.460) | (-10224.900 -2287.480) | ||||
44 | (-2152.946 633.943) | (-13241.960 3716.150) | ||||
45 | (-1908.293 -661.427) | (-8274.830 -8774.800) | ||||
46 | (-2055.084 -768.910) | (-7762.670 -9725.950) | ||||
47 | (-2104.015 -796.394) | (-7250.520 -9213.790) | ||||
48 | (-2152.946 -768.910) | (-7746.420 -8742.290) | ||||
49 | (-2152.946 -823.877) | (-6750.550 -8758.540) | ||||
50 | (-2201.876 -796.394) | (-7193.610 -8705.690) | ||||
Sheet2 |