karlos
08-07-2008, 03:44 AM
Need to get a spread sheet up and running urgently as always however the format we use has been ignored so i now need to insert thousands of lines.
I need to insert rows based on the number of sequential mumbers in previous rows. Cell A8 starts with 1 and carries on down column A with more 1s followed by 2s followed by 3s etc. each group of numbers can be upto 25 no more. Problem is some groups are less than 25 so I need to insert rows to bring the total number of rows for each number to 25.
I have attached a spread sheet to illustrate.
can anyone assits please.
I need to insert rows based on the number of sequential mumbers in previous rows. Cell A8 starts with 1 and carries on down column A with more 1s followed by 2s followed by 3s etc. each group of numbers can be upto 25 no more. Problem is some groups are less than 25 so I need to insert rows to bring the total number of rows for each number to 25.
I have attached a spread sheet to illustrate.
can anyone assits please.