Trying to Find a way to insert blank row in between rows of duplicate data

Deathe

New Member
Joined
Oct 22, 2020
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
I have a Variance spreadsheet for a bank reconciliation and it has loan numbers on it. These loan numbers have various sets of funds associated with either debits or credits, spread across maybe 8 columns and down probably 400 rows. I need a way to put a spacer row between each "block" of dupe numbers without having to scroll down by hand and click, insert row yadda yadda repeat. As there can be 3 charges to a loan up to 7, it is a variable number, so it isn't set (like a blank space every 10 rows). I cannot show a picture as the work has personal mortgage related data but I really would appreciate the help. Is there a macro or EZ key way to do this?

Thanks!
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,487
Office Version
  1. 365
Platform
  1. Windows
Hi & welcome to MrExcel.
Which column has the duplicated numbers?
 

Watch MrExcel Video

Forum statistics

Threads
1,114,584
Messages
5,548,883
Members
410,882
Latest member
ADJ
Top