Do Loops

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

I need to insert an "*" into a column every 100 records.
The file contian anywhere for 10,000 to 30,000 with
columns A, B and sometimes C. I really need it to look in
column A until it is null and then insert "*" every 100
records the end of the data in column A. HELP!
 
are you inseting a new row every 100 records or just overwritng whats found in row 101, 201...
what's the significance of Columns B & C: you mention them but don't say why

----- Sue wrote: ----

I need to insert an "*" into a column every 100 records.
The file contian anywhere for 10,000 to 30,000 with
columns A, B and sometimes C. I really need it to look in
column A until it is null and then insert "*" every 100
records the end of the data in column A. HELP!
 
You must log in or register to reply here.

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

VBA - retrieve data on last create named range from previous inserted named range 0
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Do Until empty loop 2
Mid column sum formulas with varied ranges to sum 17
insert rows and copying cells in column b,c, and d into new rows 3
Lousy routine to get the first available day of the month 2
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Strip out certain rows that have merged cells 2

Back
Top