Add 2 rows above certain cells

sharky12345

sharky12345

Well-known Member
Joined
Aug 5, 2010
Messages
3,430
Office Version
  1. 2016
Platform
  1. 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:

Import Template.xlsm
ABCDEFG
1003239921/01/2025 10:00XZDD52400032399Wednesday21/01/2025
2004959521/01/2025 12:00XZDD52400049595Wednesday21/01/2025
3005330110/02/2025 16:30XZDD52400053301Tuesday10/02/202510/02/2025
4005516719/02/2025 13:30XZDD52400055167Thursday19/02/202519/02/2025
5003783920/02/2025 09:30XZDD52400037839Friday20/02/2025
6005530320/02/2025 10:00XZDD52400055303Friday20/02/2025
7005533920/02/2025 11:00XZDD52400055339Friday20/02/2025
8005538620/02/2025 11:30XZDD52400055386Friday20/02/2025
9005537420/02/2025 12:00XZDD52400055374Friday20/02/2025
10005544020/02/2025 12:30XZDD52400055440Friday20/02/2025
11003788220/02/2025 13:30XZDD52400037882Friday20/02/2025
12005543420/02/2025 14:00XZDD52400055434Friday20/02/2025
13003969520/02/2025 14:30XZDD52400039695Friday20/02/2025
14005279420/02/2025 16:30XZDD52400052794Friday20/02/2025
15005533320/02/2025 17:00XZDD52400055333Friday20/02/202520/02/2025
16003806821/02/2025 10:30XZDD52400038068Saturday21/02/2025
17003819121/02/2025 11:00XZDD52400038191Saturday21/02/2025
18003819221/02/2025 11:30XZDD52400038192Saturday21/02/2025
19003810321/02/2025 12:00XZDD52400038103Saturday21/02/2025
20003803021/02/2025 12:30XZDD52400038030Saturday21/02/2025
21003810021/02/2025 13:00XZDD52400038100Saturday21/02/2025
22005554021/02/2025 13:30XZDD52400055540Saturday21/02/2025
23005551621/02/2025 14:00XZDD52400055516Saturday21/02/2025
24005552221/02/2025 14:30XZDD52400055522Saturday21/02/2025
25005560321/02/2025 15:00XZDD52400055603Saturday21/02/2025
26006132921/02/2025 15:30XZDD52400061329Saturday21/02/2025
27005560121/02/2025 17:00XZDD52400055601Saturday21/02/2025
28005559921/02/2025 17:30XZDD52400055599Saturday21/02/202521/02/2025
29003668922/02/2025 10:00XZDD52400036689Sunday22/02/2025
30005571022/02/2025 10:30XZDD52400055710Sunday22/02/2025
31005567022/02/2025 11:00XZDD52400055670Sunday22/02/2025
32005571122/02/2025 11:30XZDD52400055711Sunday22/02/2025
33000905622/02/2025 12:30XZDD52400009056Sunday22/02/2025
34002604222/02/2025 13:00XZDD52400026042Sunday22/02/2025
35005584922/02/2025 14:00XZDD52400055849Sunday22/02/202522/02/2025
36005588823/02/2025 11:30XZDD52400055888Monday23/02/2025
37005586223/02/2025 12:30XZDD52400055862Monday23/02/2025
38005586223/02/2025 12:30XZDD52400055862Monday23/02/2025
39005583523/02/2025 14:00XZDD52400055835Monday23/02/2025
40005583023/02/2025 14:30XZDD52400055830Monday23/02/2025
41003841723/02/2025 15:30XZDD52400038417Monday23/02/202523/02/2025
42000478724/02/2025 04:59XZDD52500004787Tuesday24/02/2025
43005586924/02/2025 10:00XZDD52400055869Tuesday24/02/2025
44005602024/02/2025 11:00XZDD52400056020Tuesday24/02/2025
45005599624/02/2025 11:30XZDD52400055996Tuesday24/02/2025
46005598024/02/2025 12:00XZDD52400055980Tuesday24/02/2025
47005601124/02/2025 12:30XZDD52400056011Tuesday24/02/2025
48005603524/02/2025 13:00XZDD52400056035Tuesday24/02/2025
49005601424/02/2025 16:30XZDD52400056014Tuesday24/02/202524/02/2025
50000485925/02/2025 00:00XZDD52500004859Wednesday25/02/2025
51004822425/02/2025 09:30XZDD52400048224Wednesday25/02/2025
52005628225/02/2025 10:00XZDD52400056282Wednesday25/02/2025
53005628425/02/2025 10:30XZDD52400056284Wednesday25/02/2025
54002144525/02/2025 11:00XZDD52400021445Wednesday25/02/2025
55005619725/02/2025 11:30XZDD52400056197Wednesday25/02/2025
56005623325/02/2025 12:00XZDD52400056233Wednesday25/02/2025
57003886525/02/2025 12:30XZDD52400038865Wednesday25/02/2025
58005631725/02/2025 13:30XZDD52400056317Wednesday25/02/2025
59005637225/02/2025 14:00XZDD52400056372Wednesday25/02/202525/02/2025
60005651926/02/2025 09:30XZDD52400056519Thursday26/02/2025
61003899126/02/2025 10:00XZDD52400038991Thursday26/02/2025
62003903426/02/2025 10:30XZDD52400039034Thursday26/02/2025
63005641926/02/2025 11:00XZDD52400056419Thursday26/02/2025
64005648526/02/2025 11:30XZDD52400056485Thursday26/02/2025
65004716326/02/2025 12:00XZDD52400047163Thursday26/02/2025
66005659926/02/2025 12:30XZDD52400056599Thursday26/02/2025
67005659926/02/2025 12:30XZDD52400056599Thursday26/02/2025
68005741526/02/2025 13:00XZDD52400057415Thursday26/02/2025
69005305626/02/2025 14:00XZDD52400053056Thursday26/02/2025
70004200226/02/2025 14:30XZDD52400042002Thursday26/02/202526/02/2025
71005730427/02/2025 08:00XZDD52400057304Friday27/02/2025
72005717927/02/2025 09:00XZDD52400057179Friday27/02/2025
73005717427/02/2025 09:30XZDD52400057174Friday27/02/2025
74005670027/02/2025 11:00XZDD52400056700Friday27/02/2025
75005670027/02/2025 11:00XZDD52400056700Friday27/02/2025
76003914927/02/2025 11:30XZDD52400039149Friday27/02/2025
77000182827/02/2025 12:00XZDD52500001828Friday27/02/2025
78003924127/02/2025 12:30XZDD52400039241Friday27/02/2025
79002181627/02/2025 13:00XZDD52400021816Friday27/02/2025
80005666327/02/2025 13:30XZDD52400056663Friday27/02/2025
81005666527/02/2025 14:00XZDD52400056665Friday27/02/2025
82005674327/02/2025 15:00XZDD52400056743Friday27/02/2025
83005703827/02/2025 16:00XZDD52400057038Friday27/02/2025
84005694327/02/2025 16:30XZDD52400056943Friday27/02/2025
85005695727/02/2025 17:00XZDD52400056957Friday27/02/2025
86005718927/02/2025 18:00XZDD52400057189Friday27/02/2025
87005736827/02/2025 18:30XZDD52400057368Friday27/02/202527/02/2025
88005701428/02/2025 08:30XZDD52400057014Saturday28/02/2025
89003969528/02/2025 09:00XZDD52400039695Saturday28/02/2025
90004393828/02/2025 10:00XZDD52400043938Saturday28/02/2025
91005688528/02/2025 10:30XZDD52400056885Saturday28/02/2025
92003939828/02/2025 11:00XZDD52400039398Saturday28/02/2025
93005682928/02/2025 11:30XZDD52400056829Saturday28/02/2025
94002222928/02/2025 12:30XZDD52400022229Saturday28/02/2025
95002222228/02/2025 14:00XZDD52400022222Saturday28/02/2025
96003940028/02/2025 16:30XZDD52400039400Saturday28/02/2025
97005689128/02/2025 17:00XZDD52400056891Saturday28/02/2025
98005688928/02/2025 17:30XZDD52400056889Saturday28/02/2025
99001592328/02/2025 17:30XZDD52300015923Saturday28/02/2025
100005699328/02/2025 18:00XZDD52400056993Saturday28/02/2025
101005699328/02/2025 18:00XZDD52400056993Saturday28/02/2025
102005719028/02/2025 19:00XZDD52400057190Saturday28/02/2025
103005727628/02/2025 19:30XZDD52400057276Saturday28/02/2025
104000561228/02/2025 23:55XZDD52500005612Saturday28/02/202528/02/2025
105005753701/03/2025 09:00XZDD52400057537Sunday01/03/2025
106005752201/03/2025 09:30XZDD52400057522Sunday01/03/2025
107004021901/03/2025 10:30XZDD52400040219Sunday01/03/2025
108004013301/03/2025 11:00XZDD52400040133Sunday01/03/2025
109005704201/03/2025 12:00XZDD52400057042Sunday01/03/2025
110005728401/03/2025 12:30XZDD52400057284Sunday01/03/2025
111005742801/03/2025 13:00XZDD52400057428Sunday01/03/2025
112005745101/03/2025 13:30XZDD52400057451Sunday01/03/2025
113005748501/03/2025 14:00XZDD52400057485Sunday01/03/2025
114005744801/03/2025 14:30XZDD52400057448Sunday01/03/2025
115005742801/03/2025 16:00XZDD52400057428Sunday01/03/2025
116005753601/03/2025 16:30XZDD52400057536Sunday01/03/202501/03/2025
117000581502/03/2025 03:56XZDD52500005815Monday02/03/2025
118005245502/03/2025 09:30XZDD52400052455Monday02/03/2025
119005769502/03/2025 10:00XZDD52400057695Monday02/03/2025
120002305702/03/2025 10:30XZDD52400023057Monday02/03/2025
121004340602/03/2025 11:00XZDD52400043406Monday02/03/2025
122005759402/03/2025 11:30XZDD52400057594Monday02/03/2025
123004043102/03/2025 12:00XZDD52400040431Monday02/03/2025
124005758702/03/2025 12:30XZDD52400057587Monday02/03/2025
125004048702/03/2025 13:00XZDD52400040487Monday02/03/2025
126004038302/03/2025 13:30XZDD52400040383Monday02/03/2025
127005765002/03/2025 14:00XZDD52400057650Monday02/03/2025
128004036802/03/2025 14:30XZDD52400040368Monday02/03/2025
129005762502/03/2025 15:00XZDD52400057625Monday02/03/2025
130005770902/03/2025 15:30XZDD52400057709Monday02/03/2025
131005762102/03/2025 16:00XZDD52400057621Monday02/03/2025
132005762702/03/2025 16:30XZDD52400057627Monday02/03/202502/03/2025
133005785003/03/2025 10:00XZDD52400057850Tuesday03/03/2025
134005785503/03/2025 10:30XZDD52400057855Tuesday03/03/2025
135005780003/03/2025 11:30XZDD52400057800Tuesday03/03/2025
136005788103/03/2025 12:00XZDD52400057881Tuesday03/03/2025
137001128803/03/2025 12:30XZDD52400011288Tuesday03/03/2025
138005786003/03/2025 14:30XZDD52400057860Tuesday03/03/2025
139004287103/03/2025 15:00XZDD52400042871Tuesday03/03/2025
140005791203/03/2025 16:00XZDD52400057912Tuesday03/03/202503/03/2025
141002995204/03/2025 09:30XZDD52400029952Wednesday04/03/2025
142004067704/03/2025 10:30XZDD52400040677Wednesday04/03/2025
143005794704/03/2025 11:00XZDD52400057947Wednesday04/03/2025
144005798604/03/2025 11:30XZDD52400057986Wednesday04/03/2025
145005797604/03/2025 12:00XZDD52400057976Wednesday04/03/2025
146002329504/03/2025 12:30XZDD52400023295Wednesday04/03/2025
147005804204/03/2025 13:00XZDD52400058042Wednesday04/03/2025
148005804204/03/2025 13:00XZDD52400058042Wednesday04/03/2025
149005808604/03/2025 13:30XZDD52400058086Wednesday04/03/2025
150005807204/03/2025 14:00XZDD52400058072Wednesday04/03/2025
151005807504/03/2025 14:30XZDD52400058075Wednesday04/03/2025
152005784204/03/2025 15:00XZDD52400057842Wednesday04/03/2025
153005810004/03/2025 16:00XZDD52400058100Wednesday04/03/2025
154002973004/03/2025 16:30XZDD52400029730Wednesday04/03/2025
155002974104/03/2025 17:30XZDD52400029741Wednesday04/03/2025
156000630204/03/2025 23:55XZDD52500006302Wednesday04/03/202504/03/2025
157005073305/03/2025 11:00XZDD52400050733Thursday05/03/2025
158005821405/03/2025 12:00XZDD52400058214Thursday05/03/2025
159005814405/03/2025 12:30XZDD52400058144Thursday05/03/2025
160005827305/03/2025 15:00XZDD52400058273Thursday05/03/2025
161005816005/03/2025 16:00XZDD52400058160Thursday05/03/2025
162005817405/03/2025 16:30XZDD52400058174Thursday05/03/2025
163005817405/03/2025 16:30XZDD52400058174Thursday05/03/2025
164005819005/03/2025 17:00XZDD52400058190Thursday05/03/202505/03/2025
165000640006/03/2025 00:29XZDD52500006400Friday06/03/2025
166001212506/03/2025 10:00XZDD52400012125Friday06/03/2025
167004104506/03/2025 10:30XZDD52400041045Friday06/03/2025
168000660506/03/2025 10:47XZDD52500006605Friday06/03/2025
169005833806/03/2025 11:00XZDD52400058338Friday06/03/2025
170002363206/03/2025 11:30XZDD52400023632Friday06/03/2025
171005839906/03/2025 12:00XZDD52400058399Friday06/03/2025
172005843306/03/2025 13:30XZDD52400058433Friday06/03/2025
173005829606/03/2025 14:00XZDD52400058296Friday06/03/2025
174005831006/03/2025 15:00XZDD52400058310Friday06/03/2025
175001265506/03/2025 15:30XZDD52400012655Friday06/03/202506/03/2025
IMPORT (2)
 
Sort by date Sort by votes
Hmmm. Try VBA to loop through column G from bottom to top, checking the values and inserting two rows each time. This will ensure all rows are added without affecting the loop index.
Please write back.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
Value Extraction
Replies
8
Views
102
Peter_SSs
Peter_SSs
A
  • Question Question
how to compute days between dates excel with per month
Replies
9
Views
127
FormR
FormR
C
  • Solved
Hiding dates if they are before a certain date
Replies
4
Views
138
chris_bosten
C
S
  • Question Question
Calculate Weekly movements
2
Replies
13
Views
148
Shp1
S
C
  • Solved
Calculate hour total for each week
2
Replies
16
Views
276
CaptainGravyBum
C

Forum statistics

Threads
1,226,795
Messages
6,193,046
Members
453,772
Latest member
aastupin

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top