ExcelBanter - fill series

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - fill series (https://www.excelbanter.com/new-users-excel/123137-fill-series.html)

FreezingInFargo

fill series

"Don Guillett" wrote:

on row 1 copied down
="1030 33rd st #"&ROW()

or a macro
for i = 1 to 400
msgbox "1033 33rd St, #" & i
next i

--
Don Guillett
SalesAid Software

"FreezingInFargo" wrote in
message ...
I want to automatically generate a sequence of numbers for apartment units
to
merge with word. I have to do a mailing list to hundreds of apartments. I
type in, say, 1030 33rd st #1, but when I do the fill series only the 1030
generates the series 1031,1032,1033 etc... I've tried to setup the unit
numbers in a separate collumn, but I cant edit the address block in word
to
merge the 2 columns on the same line in the address block.
Any help with how to exclude part of the address or otherwise only
increase
the series of the Apartment unit only would be greatly appreciated?

How would I modify the formula to use it with letters, A thru M e.g., instead of apt. numbers? And have Apartment numbers that are in multiples of 2 eg 102,104,106...? Thank for any help

Don Guillett

fill series

for i=1 to 400 step 2

--
Don Guillett
SalesAid Software

"FreezingInFargo" wrote in
message ...
"Don Guillett" wrote:

on row 1 copied down
="1030 33rd st #"&ROW()

or a macro
for i = 1 to 400
msgbox "1033 33rd St, #" & i
next i

--
Don Guillett
SalesAid Software

"FreezingInFargo" wrote in
message ...
I want to automatically generate a sequence of numbers for apartment
units
to
merge with word. I have to do a mailing list to hundreds of apartments.
I
type in, say, 1030 33rd st #1, but when I do the fill series only the
1030
generates the series 1031,1032,1033 etc... I've tried to setup the unit
numbers in a separate collumn, but I cant edit the address block in
word
to
merge the 2 columns on the same line in the address block.
Any help with how to exclude part of the address or otherwise only
increase
the series of the Apartment unit only would be greatly appreciated?

How would I modify the formula to use it with letters, A thru M e.g.,
instead of apt. numbers? And have Apartment numbers that are in multiples
of 2 eg 102,104,106...? Thank for any help

All times are GMT +1. The time now is 07:55 PM.