About Us

FreezingInFargo

"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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to fill cells with a different kind of series?	Jared	Excel Worksheet Functions	1	July 27th 06 12:37 AM
Auto Fill Series issue...	e3donald	Excel Discussion (Misc queries)	3	April 26th 06 08:08 PM
Auto Fill Series when number ends in -1	JGus	Excel Discussion (Misc queries)	7	December 23rd 05 03:14 AM
Fill series but a little different	kingjeremy	Excel Discussion (Misc queries)	5	August 20th 05 01:18 PM
Excel should not automatically extend series or fill values	whisperlm	Excel Discussion (Misc queries)	0	July 13th 05 07:06 PM

Menu

About Us