How can I fill a series in Nonadjacent cells eg Text 1, Text 2
 

How can I continue a series of Text and Number values if the cells are not
adjacent? The values would be something like: Text 1, Text 2 etc. I need
to be able to change the cell containing Text 1 to Text 12 for example and
have all the other cells fill in sequentially, so that I would have Text 12,
Text 13 etc.

How can I fill a series in Nonadjacent cells eg Text 1, Text 2
 

I think of only a small macro (perhaps other solutions may be available)
give a name to the range of nonadjacent cells e.g. rv
then use this macro

Sub test()
Dim c As Range
Dim j As Integer
j = 0
For Each c In Range("rv")
j = j + 1
c = j
Next
End Sub


"juikijui" wrote in message
...
How can I continue a series of Text and Number values if the cells are not
adjacent? The values would be something like: Text 1, Text 2 etc. I
need
to be able to change the cell containing Text 1 to Text 12 for example and
have all the other cells fill in sequentially, so that I would have Text
12,
Text 13 etc.

How can I fill a series in Nonadjacent cells eg Text 1, Text 2
 

How / where are the cells you want to fill situated?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"juikijui" wrote in message
...
How can I continue a series of Text and Number values if the cells are not
adjacent? The values would be something like: Text 1, Text 2 etc. I
need
to be able to change the cell containing Text 1 to Text 12 for example and
have all the other cells fill in sequentially, so that I would have Text
12,
Text 13 etc.

How can I fill a series in Nonadjacent cells eg Text 1, Text 2
 

It would look something like this:

a1=Text 1 d1=Text 2
a2=Text 3 d2=Text 4

a12=Text 5 d12=Text 6
a13=Text 7 d14=Text 8

etc... to Text 160

How can I fill a series in Nonadjacent cells eg Text 1, Text 2
 

Where is the text data located?

Is it in a single column ... single row ... multiple locations?
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Juikijui" wrote in message
oups.com...
It would look something like this:

a1=Text 1 d1=Text 2
a2=Text 3 d2=Text 4

a12=Text 5 d12=Text 6
a13=Text 7 d14=Text 8

etc... to Text 160

How can I fill a series in Nonadjacent cells eg Text 1, Text 2
 

The text data is located in a single column. I don't mind entering a formula
in each of the 160 nonadjacent cells, I just need to be able to change the
starting numerical portion of the first cell and have that change all the
following numerical portions of each cell entry.

"RagDyeR" wrote:

Where is the text data located?

Is it in a single column ... single row ... multiple locations?
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Juikijui" wrote in message
oups.com...
It would look something like this:

a1=Text 1 d1=Text 2
a2=Text 3 d2=Text 4

a12=Text 5 d12=Text 6
a13=Text 7 d14=Text 8

etc... to Text 160

How can I fill a series in Nonadjacent cells eg Text 1, Text 2
 

I believe that you'll need some code to accomplish all that you're asking
for.

Sorry, but I can't help with that.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"juikijui" wrote in message
...
The text data is located in a single column. I don't mind entering a
formula
in each of the 160 nonadjacent cells, I just need to be able to change the
starting numerical portion of the first cell and have that change all the
following numerical portions of each cell entry.

"RagDyeR" wrote:

Where is the text data located?

Is it in a single column ... single row ... multiple locations?
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Juikijui" wrote in message
oups.com...
It would look something like this:

a1=Text 1 d1=Text 2
a2=Text 3 d2=Text 4

a12=Text 5 d12=Text 6
a13=Text 7 d14=Text 8

etc... to Text 160