software

I have a rather large workbook, with many lists of numbers on various
worksheets. These list span from 1 through 28. I need to change them all to
span 1 through 30. They are in many different locations within the workbook.
It is not practical to find them all, and change them by the quot;fillquot; process.
It will take far to long and I might miss one or two.
Is there a way to accomplish this.

Thanks
Paul

Please provide a little more info........are the 1-28 numbers down a column,
or across a row..........is there more than one group on each Sheet?.....is
there any consistancy between sheets? Is there any cell that is always
within an exact location from each range of numbers?, etc etc etc.......

tks
Vaya con Dios,
Chuck, CABGx3
quot;PAquot; wrote:

gt; I have a rather large workbook, with many lists of numbers on various
gt; worksheets. These list span from 1 through 28. I need to change them all to
gt; span 1 through 30. They are in many different locations within the workbook.
gt; It is not practical to find them all, and change them by the quot;fillquot; process.
gt; It will take far to long and I might miss one or two.
gt; Is there a way to accomplish this.
gt;
gt; Thanks
gt; Paul

Thanks for your response and interest.
I have checked back witht he user:

The numbers are in coulumns, not necessarily in order although most will be
the number 28. There is definately more than one group on each sheet. The
starting location for each group will always be the same, but there are many
of them
Paul

quot;CLRquot; wrote:

gt; Please provide a little more info........are the 1-28 numbers down a column,
gt; or across a row..........is there more than one group on each Sheet?.....is
gt; there any consistancy between sheets? Is there any cell that is always
gt; within an exact location from each range of numbers?, etc etc etc.......
gt;
gt; tks
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;PAquot; wrote:
gt;
gt; gt; I have a rather large workbook, with many lists of numbers on various
gt; gt; worksheets. These list span from 1 through 28. I need to change them all to
gt; gt; span 1 through 30. They are in many different locations within the workbook.
gt; gt; It is not practical to find them all, and change them by the quot;fillquot; process.
gt; gt; It will take far to long and I might miss one or two.
gt; gt; Is there a way to accomplish this.
gt; gt;
gt; gt; Thanks
gt; gt; Paul

Hi PA.....

This one should be solvable, but will take VBA skill beyond mine. I suggest
you get some more facts together, such as the list of ranges of all the
groups on the sheet with the most groups, and repost your problem to the
microsoft.public.excel.Programming group. Someone there should be able to
give you code to do some global searching and adding to the groups....

Vaya con Dios,
Chuck CABGx3quot;PAquot; wrote:

gt; Thanks for your response and interest.
gt; I have checked back witht he user:
gt;
gt; The numbers are in coulumns, not necessarily in order although most will be
gt; the number 28. There is definately more than one group on each sheet. The
gt; starting location for each group will always be the same, but there are many
gt; of them
gt; Paul
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; Please provide a little more info........are the 1-28 numbers down a column,
gt; gt; or across a row..........is there more than one group on each Sheet?.....is
gt; gt; there any consistancy between sheets? Is there any cell that is always
gt; gt; within an exact location from each range of numbers?, etc etc etc.......
gt; gt;
gt; gt; tks
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;PAquot; wrote:
gt; gt;
gt; gt; gt; I have a rather large workbook, with many lists of numbers on various
gt; gt; gt; worksheets. These list span from 1 through 28. I need to change them all to
gt; gt; gt; span 1 through 30. They are in many different locations within the workbook.
gt; gt; gt; It is not practical to find them all, and change them by the quot;fillquot; process.
gt; gt; gt; It will take far to long and I might miss one or two.
gt; gt; gt; Is there a way to accomplish this.
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt; gt; Paul

Thanks, I will do that

quot;CLRquot; wrote:

gt; Hi PA.....
gt;
gt; This one should be solvable, but will take VBA skill beyond mine. I suggest
gt; you get some more facts together, such as the list of ranges of all the
gt; groups on the sheet with the most groups, and repost your problem to the
gt; microsoft.public.excel.Programming group. Someone there should be able to
gt; give you code to do some global searching and adding to the groups....
gt;
gt; Vaya con Dios,
gt; Chuck CABGx3
gt;
gt;
gt;
gt;
gt;
gt; quot;PAquot; wrote:
gt;
gt; gt; Thanks for your response and interest.
gt; gt; I have checked back witht he user:
gt; gt;
gt; gt; The numbers are in coulumns, not necessarily in order although most will be
gt; gt; the number 28. There is definately more than one group on each sheet. The
gt; gt; starting location for each group will always be the same, but there are many
gt; gt; of them
gt; gt; Paul
gt; gt;
gt; gt; quot;CLRquot; wrote:
gt; gt;
gt; gt; gt; Please provide a little more info........are the 1-28 numbers down a column,
gt; gt; gt; or across a row..........is there more than one group on each Sheet?.....is
gt; gt; gt; there any consistancy between sheets? Is there any cell that is always
gt; gt; gt; within an exact location from each range of numbers?, etc etc etc.......
gt; gt; gt;
gt; gt; gt; tks
gt; gt; gt; Vaya con Dios,
gt; gt; gt; Chuck, CABGx3
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;PAquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have a rather large workbook, with many lists of numbers on various
gt; gt; gt; gt; worksheets. These list span from 1 through 28. I need to change them all to
gt; gt; gt; gt; span 1 through 30. They are in many different locations within the workbook.
gt; gt; gt; gt; It is not practical to find them all, and change them by the quot;fillquot; process.
gt; gt; gt; gt; It will take far to long and I might miss one or two.
gt; gt; gt; gt; Is there a way to accomplish this.
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks
gt; gt; gt; gt; Paul