If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding rows
I have a 800 line workbook that I want to add rows to. I only want to add a
row to every 8th row but I don't want to do it by hand. I can't find any place to do a "conditional" add a row. Thanks |
#2
|
|||
|
|||
Adding rows
Add a helper column.
Number the rows 1 through 7, 9 though 15 etc. Number remaining rows 8, 16 etc. (Highlighting at least two cells and extending them takes the tedium out of it). Sort the spread sheet on the helper column. Regards. Bill Ridgeway Computer Solutions "cdavis82" wrote in message ... I have a 800 line workbook that I want to add rows to. I only want to add a row to every 8th row but I don't want to do it by hand. I can't find any place to do a "conditional" add a row. Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data from Form is adding into table as 2 rows | melwester | General Discussion | 3 | September 29th, 2005 07:39 PM |
adding ROWS | Colin2u | General Discussion | 1 | September 5th, 2005 09:55 PM |
Adding Prefix to multiple rows n Access? Help! | Christine via AccessMonster.com | Running & Setting Up Queries | 9 | May 25th, 2005 06:19 AM |
Inserting multiple rows into a table while maintaining data? | JAnderson | General Discussion | 2 | July 8th, 2004 05:45 PM |
Prevent User from Adding Rows | Kim | Tables | 6 | June 16th, 2004 08:44 PM |