Insert, Delete, Copy, Select by Row Intervals

DigDB

Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download ^{free 15-day trial} | Purchase | FAQ | Contact

Insert, Delete, Copy, Select by Row Intervals

Insert - insert a blank row or a selected range before or after the rows after each interval.
Copy out - rows after each interval will be copied to a new sheet.
Select - rows after each interval will be selected and highlighted.
Mark - rows after each interval will be marked by a 'x'
Delete - rows after each interval will be deleted

You will need to set 2 parameters to decide which rows to apply the action:

Starting row number
Interval

Action will take place on the starting row and the rows after each interval. For example,

Starting row = 1, Interval = 1, then rows = 1, 3, 5, 7, ...
if current row = 1, then the next row after an interval of 1 will be 3 (not 2), and the next will be 5
Starting row = 1, Interval = 2, then rows = 1, 4, 7, 11, ...
Starting row = 2, Interval = 1, then rows = 2, 4, 6, 8, ...
Starting row = 2, Interval = 2, then rows = 2, 5, 8, 11, ...

If this is confusing to you, apply 'DigDB->Row Interval->Select...' action on your data first. This action will not change anything, it only selects the rows after each interval, thus showing you the rows that other actions will act on. Below is a demo of the Select by Row Interval action:

Click a single cell in the table area, then invoke 'DigDB->Row Interval->Select...'

Practice file - row-intervals-demo.xls (16k)
The table will be automatically selected. Now you can set the intervals for action.

Staring from Row 1, after an interval of 2, rows to act will be 1, 4, 7, 11 ...

This action shows what rows will be affected under the starting row and interval settings. You can run this action to verify the settings, then do the Insert, Copy out, Mark, Delete.

Need more?

Browse the complete list of DigDB's powerful features listed on the front page.
If you see errors or things not working, check out our error reference page.

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.