Insert rows throughout a table

S

Steve

Hello -

Perhaps I can solve my earlier posting if I can do the following....

I have a table that has several thousand rows.
Each row begins with a social security number, and there are varying
numbers of rows for each SSN.

If I insert a column next to the SSNs and make it a counter, I can
determine what the maximum nunber of SSNs I have as well as how many
of each I have.

I'd like to do a macro that scans the counter column downward and
inserts new rows, each with the SSN and counter+1 until the counter=
the maximim described above.

The result is the same number of rows for all SSNs no matter how many
there were to begin with and the total per SSN equal to the maximum
described above.

Can anyone help me here?

Thanks!

steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format column widths from one table to a separate table on same page 1
Insert Index into a Table 1
append multiple worksheets data into a single multi-dimensional array 4
Inserting a Copied Row inside a table 6
formula to count matching days between two date ranges (for largelist of names) 2
Macro to fill down automatically the number of rows in a spreadsheet 1
Insert row after blank cell encountered 6
Macro to combine variable multiple rows 8

Top