How To Insert A Row After Specific Criteria

**PaddyP** · 10-05-2020, 03:16 PM

Hello,

I have a long list of dates. I need to insert two rows below each new date. Any shortcuts on how to do this.

Sheet 1 is a small portion of my data. Sheet 2 is how I want the data to look.

Thank you!

**Logit** · 10-05-2020, 05:38 PM

.
You can use a loop within a macro :

Please Login or Register  to view this content.

**Logit** · 10-05-2020, 06:20 PM

.
To insert TWO BLANK ROWS ...

Please Login or Register  to view this content.

**PaddyP** · 10-06-2020, 08:16 AM

Thank you. I will give this a shot.

How To Insert A Row After Specific Criteria

LinkBack

Thread Tools

Rate This Thread

Display

How To Insert A Row After Specific Criteria

Re: How To Insert A Row After Specific Criteria

Re: How To Insert A Row After Specific Criteria

Re: How To Insert A Row After Specific Criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Match Record based on criteria and insert in specific cell on 2nd sheet

Insert rows to the top of the sheet that meet specific criteria.

[SOLVED] VBA code to insert line break within a cell if specific criteria is met.

Insert multiple pictures from specific cell values in specific cells

[SOLVED] Insert Rows on Criteria and Copy content to Specific Cells in New Rows(Tables)

[SOLVED] format cell to always insert specific thing, when a specific name is typed???

Macro to insert data in specific cell based on criteria

Bookmarks

Bookmarks

Posting Permissions