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!
Thanks!