sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,430
- Office Version
- 2016
- Platform
- Windows
I'm trying to find an efficient method to add 2 new rows under each cell in column G that has a value. I really don't know where to start - I know how to insert a new row, but can't work out how to do it twice and only where there is a value in column G.
Can anyone assist me please? I've attached a sample of the range I'm working with:
Can anyone assist me please? I've attached a sample of the range I'm working with:
Import Template.xlsm | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | 0032399 | 21/01/2025 10:00 | XZDD52400032399 | Wednesday | 21/01/2025 | ||||
2 | 0049595 | 21/01/2025 12:00 | XZDD52400049595 | Wednesday | 21/01/2025 | ||||
3 | 0053301 | 10/02/2025 16:30 | XZDD52400053301 | Tuesday | 10/02/2025 | 10/02/2025 | |||
4 | 0055167 | 19/02/2025 13:30 | XZDD52400055167 | Thursday | 19/02/2025 | 19/02/2025 | |||
5 | 0037839 | 20/02/2025 09:30 | XZDD52400037839 | Friday | 20/02/2025 | ||||
6 | 0055303 | 20/02/2025 10:00 | XZDD52400055303 | Friday | 20/02/2025 | ||||
7 | 0055339 | 20/02/2025 11:00 | XZDD52400055339 | Friday | 20/02/2025 | ||||
8 | 0055386 | 20/02/2025 11:30 | XZDD52400055386 | Friday | 20/02/2025 | ||||
9 | 0055374 | 20/02/2025 12:00 | XZDD52400055374 | Friday | 20/02/2025 | ||||
10 | 0055440 | 20/02/2025 12:30 | XZDD52400055440 | Friday | 20/02/2025 | ||||
11 | 0037882 | 20/02/2025 13:30 | XZDD52400037882 | Friday | 20/02/2025 | ||||
12 | 0055434 | 20/02/2025 14:00 | XZDD52400055434 | Friday | 20/02/2025 | ||||
13 | 0039695 | 20/02/2025 14:30 | XZDD52400039695 | Friday | 20/02/2025 | ||||
14 | 0052794 | 20/02/2025 16:30 | XZDD52400052794 | Friday | 20/02/2025 | ||||
15 | 0055333 | 20/02/2025 17:00 | XZDD52400055333 | Friday | 20/02/2025 | 20/02/2025 | |||
16 | 0038068 | 21/02/2025 10:30 | XZDD52400038068 | Saturday | 21/02/2025 | ||||
17 | 0038191 | 21/02/2025 11:00 | XZDD52400038191 | Saturday | 21/02/2025 | ||||
18 | 0038192 | 21/02/2025 11:30 | XZDD52400038192 | Saturday | 21/02/2025 | ||||
19 | 0038103 | 21/02/2025 12:00 | XZDD52400038103 | Saturday | 21/02/2025 | ||||
20 | 0038030 | 21/02/2025 12:30 | XZDD52400038030 | Saturday | 21/02/2025 | ||||
21 | 0038100 | 21/02/2025 13:00 | XZDD52400038100 | Saturday | 21/02/2025 | ||||
22 | 0055540 | 21/02/2025 13:30 | XZDD52400055540 | Saturday | 21/02/2025 | ||||
23 | 0055516 | 21/02/2025 14:00 | XZDD52400055516 | Saturday | 21/02/2025 | ||||
24 | 0055522 | 21/02/2025 14:30 | XZDD52400055522 | Saturday | 21/02/2025 | ||||
25 | 0055603 | 21/02/2025 15:00 | XZDD52400055603 | Saturday | 21/02/2025 | ||||
26 | 0061329 | 21/02/2025 15:30 | XZDD52400061329 | Saturday | 21/02/2025 | ||||
27 | 0055601 | 21/02/2025 17:00 | XZDD52400055601 | Saturday | 21/02/2025 | ||||
28 | 0055599 | 21/02/2025 17:30 | XZDD52400055599 | Saturday | 21/02/2025 | 21/02/2025 | |||
29 | 0036689 | 22/02/2025 10:00 | XZDD52400036689 | Sunday | 22/02/2025 | ||||
30 | 0055710 | 22/02/2025 10:30 | XZDD52400055710 | Sunday | 22/02/2025 | ||||
31 | 0055670 | 22/02/2025 11:00 | XZDD52400055670 | Sunday | 22/02/2025 | ||||
32 | 0055711 | 22/02/2025 11:30 | XZDD52400055711 | Sunday | 22/02/2025 | ||||
33 | 0009056 | 22/02/2025 12:30 | XZDD52400009056 | Sunday | 22/02/2025 | ||||
34 | 0026042 | 22/02/2025 13:00 | XZDD52400026042 | Sunday | 22/02/2025 | ||||
35 | 0055849 | 22/02/2025 14:00 | XZDD52400055849 | Sunday | 22/02/2025 | 22/02/2025 | |||
36 | 0055888 | 23/02/2025 11:30 | XZDD52400055888 | Monday | 23/02/2025 | ||||
37 | 0055862 | 23/02/2025 12:30 | XZDD52400055862 | Monday | 23/02/2025 | ||||
38 | 0055862 | 23/02/2025 12:30 | XZDD52400055862 | Monday | 23/02/2025 | ||||
39 | 0055835 | 23/02/2025 14:00 | XZDD52400055835 | Monday | 23/02/2025 | ||||
40 | 0055830 | 23/02/2025 14:30 | XZDD52400055830 | Monday | 23/02/2025 | ||||
41 | 0038417 | 23/02/2025 15:30 | XZDD52400038417 | Monday | 23/02/2025 | 23/02/2025 | |||
42 | 0004787 | 24/02/2025 04:59 | XZDD52500004787 | Tuesday | 24/02/2025 | ||||
43 | 0055869 | 24/02/2025 10:00 | XZDD52400055869 | Tuesday | 24/02/2025 | ||||
44 | 0056020 | 24/02/2025 11:00 | XZDD52400056020 | Tuesday | 24/02/2025 | ||||
45 | 0055996 | 24/02/2025 11:30 | XZDD52400055996 | Tuesday | 24/02/2025 | ||||
46 | 0055980 | 24/02/2025 12:00 | XZDD52400055980 | Tuesday | 24/02/2025 | ||||
47 | 0056011 | 24/02/2025 12:30 | XZDD52400056011 | Tuesday | 24/02/2025 | ||||
48 | 0056035 | 24/02/2025 13:00 | XZDD52400056035 | Tuesday | 24/02/2025 | ||||
49 | 0056014 | 24/02/2025 16:30 | XZDD52400056014 | Tuesday | 24/02/2025 | 24/02/2025 | |||
50 | 0004859 | 25/02/2025 00:00 | XZDD52500004859 | Wednesday | 25/02/2025 | ||||
51 | 0048224 | 25/02/2025 09:30 | XZDD52400048224 | Wednesday | 25/02/2025 | ||||
52 | 0056282 | 25/02/2025 10:00 | XZDD52400056282 | Wednesday | 25/02/2025 | ||||
53 | 0056284 | 25/02/2025 10:30 | XZDD52400056284 | Wednesday | 25/02/2025 | ||||
54 | 0021445 | 25/02/2025 11:00 | XZDD52400021445 | Wednesday | 25/02/2025 | ||||
55 | 0056197 | 25/02/2025 11:30 | XZDD52400056197 | Wednesday | 25/02/2025 | ||||
56 | 0056233 | 25/02/2025 12:00 | XZDD52400056233 | Wednesday | 25/02/2025 | ||||
57 | 0038865 | 25/02/2025 12:30 | XZDD52400038865 | Wednesday | 25/02/2025 | ||||
58 | 0056317 | 25/02/2025 13:30 | XZDD52400056317 | Wednesday | 25/02/2025 | ||||
59 | 0056372 | 25/02/2025 14:00 | XZDD52400056372 | Wednesday | 25/02/2025 | 25/02/2025 | |||
60 | 0056519 | 26/02/2025 09:30 | XZDD52400056519 | Thursday | 26/02/2025 | ||||
61 | 0038991 | 26/02/2025 10:00 | XZDD52400038991 | Thursday | 26/02/2025 | ||||
62 | 0039034 | 26/02/2025 10:30 | XZDD52400039034 | Thursday | 26/02/2025 | ||||
63 | 0056419 | 26/02/2025 11:00 | XZDD52400056419 | Thursday | 26/02/2025 | ||||
64 | 0056485 | 26/02/2025 11:30 | XZDD52400056485 | Thursday | 26/02/2025 | ||||
65 | 0047163 | 26/02/2025 12:00 | XZDD52400047163 | Thursday | 26/02/2025 | ||||
66 | 0056599 | 26/02/2025 12:30 | XZDD52400056599 | Thursday | 26/02/2025 | ||||
67 | 0056599 | 26/02/2025 12:30 | XZDD52400056599 | Thursday | 26/02/2025 | ||||
68 | 0057415 | 26/02/2025 13:00 | XZDD52400057415 | Thursday | 26/02/2025 | ||||
69 | 0053056 | 26/02/2025 14:00 | XZDD52400053056 | Thursday | 26/02/2025 | ||||
70 | 0042002 | 26/02/2025 14:30 | XZDD52400042002 | Thursday | 26/02/2025 | 26/02/2025 | |||
71 | 0057304 | 27/02/2025 08:00 | XZDD52400057304 | Friday | 27/02/2025 | ||||
72 | 0057179 | 27/02/2025 09:00 | XZDD52400057179 | Friday | 27/02/2025 | ||||
73 | 0057174 | 27/02/2025 09:30 | XZDD52400057174 | Friday | 27/02/2025 | ||||
74 | 0056700 | 27/02/2025 11:00 | XZDD52400056700 | Friday | 27/02/2025 | ||||
75 | 0056700 | 27/02/2025 11:00 | XZDD52400056700 | Friday | 27/02/2025 | ||||
76 | 0039149 | 27/02/2025 11:30 | XZDD52400039149 | Friday | 27/02/2025 | ||||
77 | 0001828 | 27/02/2025 12:00 | XZDD52500001828 | Friday | 27/02/2025 | ||||
78 | 0039241 | 27/02/2025 12:30 | XZDD52400039241 | Friday | 27/02/2025 | ||||
79 | 0021816 | 27/02/2025 13:00 | XZDD52400021816 | Friday | 27/02/2025 | ||||
80 | 0056663 | 27/02/2025 13:30 | XZDD52400056663 | Friday | 27/02/2025 | ||||
81 | 0056665 | 27/02/2025 14:00 | XZDD52400056665 | Friday | 27/02/2025 | ||||
82 | 0056743 | 27/02/2025 15:00 | XZDD52400056743 | Friday | 27/02/2025 | ||||
83 | 0057038 | 27/02/2025 16:00 | XZDD52400057038 | Friday | 27/02/2025 | ||||
84 | 0056943 | 27/02/2025 16:30 | XZDD52400056943 | Friday | 27/02/2025 | ||||
85 | 0056957 | 27/02/2025 17:00 | XZDD52400056957 | Friday | 27/02/2025 | ||||
86 | 0057189 | 27/02/2025 18:00 | XZDD52400057189 | Friday | 27/02/2025 | ||||
87 | 0057368 | 27/02/2025 18:30 | XZDD52400057368 | Friday | 27/02/2025 | 27/02/2025 | |||
88 | 0057014 | 28/02/2025 08:30 | XZDD52400057014 | Saturday | 28/02/2025 | ||||
89 | 0039695 | 28/02/2025 09:00 | XZDD52400039695 | Saturday | 28/02/2025 | ||||
90 | 0043938 | 28/02/2025 10:00 | XZDD52400043938 | Saturday | 28/02/2025 | ||||
91 | 0056885 | 28/02/2025 10:30 | XZDD52400056885 | Saturday | 28/02/2025 | ||||
92 | 0039398 | 28/02/2025 11:00 | XZDD52400039398 | Saturday | 28/02/2025 | ||||
93 | 0056829 | 28/02/2025 11:30 | XZDD52400056829 | Saturday | 28/02/2025 | ||||
94 | 0022229 | 28/02/2025 12:30 | XZDD52400022229 | Saturday | 28/02/2025 | ||||
95 | 0022222 | 28/02/2025 14:00 | XZDD52400022222 | Saturday | 28/02/2025 | ||||
96 | 0039400 | 28/02/2025 16:30 | XZDD52400039400 | Saturday | 28/02/2025 | ||||
97 | 0056891 | 28/02/2025 17:00 | XZDD52400056891 | Saturday | 28/02/2025 | ||||
98 | 0056889 | 28/02/2025 17:30 | XZDD52400056889 | Saturday | 28/02/2025 | ||||
99 | 0015923 | 28/02/2025 17:30 | XZDD52300015923 | Saturday | 28/02/2025 | ||||
100 | 0056993 | 28/02/2025 18:00 | XZDD52400056993 | Saturday | 28/02/2025 | ||||
101 | 0056993 | 28/02/2025 18:00 | XZDD52400056993 | Saturday | 28/02/2025 | ||||
102 | 0057190 | 28/02/2025 19:00 | XZDD52400057190 | Saturday | 28/02/2025 | ||||
103 | 0057276 | 28/02/2025 19:30 | XZDD52400057276 | Saturday | 28/02/2025 | ||||
104 | 0005612 | 28/02/2025 23:55 | XZDD52500005612 | Saturday | 28/02/2025 | 28/02/2025 | |||
105 | 0057537 | 01/03/2025 09:00 | XZDD52400057537 | Sunday | 01/03/2025 | ||||
106 | 0057522 | 01/03/2025 09:30 | XZDD52400057522 | Sunday | 01/03/2025 | ||||
107 | 0040219 | 01/03/2025 10:30 | XZDD52400040219 | Sunday | 01/03/2025 | ||||
108 | 0040133 | 01/03/2025 11:00 | XZDD52400040133 | Sunday | 01/03/2025 | ||||
109 | 0057042 | 01/03/2025 12:00 | XZDD52400057042 | Sunday | 01/03/2025 | ||||
110 | 0057284 | 01/03/2025 12:30 | XZDD52400057284 | Sunday | 01/03/2025 | ||||
111 | 0057428 | 01/03/2025 13:00 | XZDD52400057428 | Sunday | 01/03/2025 | ||||
112 | 0057451 | 01/03/2025 13:30 | XZDD52400057451 | Sunday | 01/03/2025 | ||||
113 | 0057485 | 01/03/2025 14:00 | XZDD52400057485 | Sunday | 01/03/2025 | ||||
114 | 0057448 | 01/03/2025 14:30 | XZDD52400057448 | Sunday | 01/03/2025 | ||||
115 | 0057428 | 01/03/2025 16:00 | XZDD52400057428 | Sunday | 01/03/2025 | ||||
116 | 0057536 | 01/03/2025 16:30 | XZDD52400057536 | Sunday | 01/03/2025 | 01/03/2025 | |||
117 | 0005815 | 02/03/2025 03:56 | XZDD52500005815 | Monday | 02/03/2025 | ||||
118 | 0052455 | 02/03/2025 09:30 | XZDD52400052455 | Monday | 02/03/2025 | ||||
119 | 0057695 | 02/03/2025 10:00 | XZDD52400057695 | Monday | 02/03/2025 | ||||
120 | 0023057 | 02/03/2025 10:30 | XZDD52400023057 | Monday | 02/03/2025 | ||||
121 | 0043406 | 02/03/2025 11:00 | XZDD52400043406 | Monday | 02/03/2025 | ||||
122 | 0057594 | 02/03/2025 11:30 | XZDD52400057594 | Monday | 02/03/2025 | ||||
123 | 0040431 | 02/03/2025 12:00 | XZDD52400040431 | Monday | 02/03/2025 | ||||
124 | 0057587 | 02/03/2025 12:30 | XZDD52400057587 | Monday | 02/03/2025 | ||||
125 | 0040487 | 02/03/2025 13:00 | XZDD52400040487 | Monday | 02/03/2025 | ||||
126 | 0040383 | 02/03/2025 13:30 | XZDD52400040383 | Monday | 02/03/2025 | ||||
127 | 0057650 | 02/03/2025 14:00 | XZDD52400057650 | Monday | 02/03/2025 | ||||
128 | 0040368 | 02/03/2025 14:30 | XZDD52400040368 | Monday | 02/03/2025 | ||||
129 | 0057625 | 02/03/2025 15:00 | XZDD52400057625 | Monday | 02/03/2025 | ||||
130 | 0057709 | 02/03/2025 15:30 | XZDD52400057709 | Monday | 02/03/2025 | ||||
131 | 0057621 | 02/03/2025 16:00 | XZDD52400057621 | Monday | 02/03/2025 | ||||
132 | 0057627 | 02/03/2025 16:30 | XZDD52400057627 | Monday | 02/03/2025 | 02/03/2025 | |||
133 | 0057850 | 03/03/2025 10:00 | XZDD52400057850 | Tuesday | 03/03/2025 | ||||
134 | 0057855 | 03/03/2025 10:30 | XZDD52400057855 | Tuesday | 03/03/2025 | ||||
135 | 0057800 | 03/03/2025 11:30 | XZDD52400057800 | Tuesday | 03/03/2025 | ||||
136 | 0057881 | 03/03/2025 12:00 | XZDD52400057881 | Tuesday | 03/03/2025 | ||||
137 | 0011288 | 03/03/2025 12:30 | XZDD52400011288 | Tuesday | 03/03/2025 | ||||
138 | 0057860 | 03/03/2025 14:30 | XZDD52400057860 | Tuesday | 03/03/2025 | ||||
139 | 0042871 | 03/03/2025 15:00 | XZDD52400042871 | Tuesday | 03/03/2025 | ||||
140 | 0057912 | 03/03/2025 16:00 | XZDD52400057912 | Tuesday | 03/03/2025 | 03/03/2025 | |||
141 | 0029952 | 04/03/2025 09:30 | XZDD52400029952 | Wednesday | 04/03/2025 | ||||
142 | 0040677 | 04/03/2025 10:30 | XZDD52400040677 | Wednesday | 04/03/2025 | ||||
143 | 0057947 | 04/03/2025 11:00 | XZDD52400057947 | Wednesday | 04/03/2025 | ||||
144 | 0057986 | 04/03/2025 11:30 | XZDD52400057986 | Wednesday | 04/03/2025 | ||||
145 | 0057976 | 04/03/2025 12:00 | XZDD52400057976 | Wednesday | 04/03/2025 | ||||
146 | 0023295 | 04/03/2025 12:30 | XZDD52400023295 | Wednesday | 04/03/2025 | ||||
147 | 0058042 | 04/03/2025 13:00 | XZDD52400058042 | Wednesday | 04/03/2025 | ||||
148 | 0058042 | 04/03/2025 13:00 | XZDD52400058042 | Wednesday | 04/03/2025 | ||||
149 | 0058086 | 04/03/2025 13:30 | XZDD52400058086 | Wednesday | 04/03/2025 | ||||
150 | 0058072 | 04/03/2025 14:00 | XZDD52400058072 | Wednesday | 04/03/2025 | ||||
151 | 0058075 | 04/03/2025 14:30 | XZDD52400058075 | Wednesday | 04/03/2025 | ||||
152 | 0057842 | 04/03/2025 15:00 | XZDD52400057842 | Wednesday | 04/03/2025 | ||||
153 | 0058100 | 04/03/2025 16:00 | XZDD52400058100 | Wednesday | 04/03/2025 | ||||
154 | 0029730 | 04/03/2025 16:30 | XZDD52400029730 | Wednesday | 04/03/2025 | ||||
155 | 0029741 | 04/03/2025 17:30 | XZDD52400029741 | Wednesday | 04/03/2025 | ||||
156 | 0006302 | 04/03/2025 23:55 | XZDD52500006302 | Wednesday | 04/03/2025 | 04/03/2025 | |||
157 | 0050733 | 05/03/2025 11:00 | XZDD52400050733 | Thursday | 05/03/2025 | ||||
158 | 0058214 | 05/03/2025 12:00 | XZDD52400058214 | Thursday | 05/03/2025 | ||||
159 | 0058144 | 05/03/2025 12:30 | XZDD52400058144 | Thursday | 05/03/2025 | ||||
160 | 0058273 | 05/03/2025 15:00 | XZDD52400058273 | Thursday | 05/03/2025 | ||||
161 | 0058160 | 05/03/2025 16:00 | XZDD52400058160 | Thursday | 05/03/2025 | ||||
162 | 0058174 | 05/03/2025 16:30 | XZDD52400058174 | Thursday | 05/03/2025 | ||||
163 | 0058174 | 05/03/2025 16:30 | XZDD52400058174 | Thursday | 05/03/2025 | ||||
164 | 0058190 | 05/03/2025 17:00 | XZDD52400058190 | Thursday | 05/03/2025 | 05/03/2025 | |||
165 | 0006400 | 06/03/2025 00:29 | XZDD52500006400 | Friday | 06/03/2025 | ||||
166 | 0012125 | 06/03/2025 10:00 | XZDD52400012125 | Friday | 06/03/2025 | ||||
167 | 0041045 | 06/03/2025 10:30 | XZDD52400041045 | Friday | 06/03/2025 | ||||
168 | 0006605 | 06/03/2025 10:47 | XZDD52500006605 | Friday | 06/03/2025 | ||||
169 | 0058338 | 06/03/2025 11:00 | XZDD52400058338 | Friday | 06/03/2025 | ||||
170 | 0023632 | 06/03/2025 11:30 | XZDD52400023632 | Friday | 06/03/2025 | ||||
171 | 0058399 | 06/03/2025 12:00 | XZDD52400058399 | Friday | 06/03/2025 | ||||
172 | 0058433 | 06/03/2025 13:30 | XZDD52400058433 | Friday | 06/03/2025 | ||||
173 | 0058296 | 06/03/2025 14:00 | XZDD52400058296 | Friday | 06/03/2025 | ||||
174 | 0058310 | 06/03/2025 15:00 | XZDD52400058310 | Friday | 06/03/2025 | ||||
175 | 0012655 | 06/03/2025 15:30 | XZDD52400012655 | Friday | 06/03/2025 | 06/03/2025 | |||
IMPORT (2) |