| Home |
| Search |
| Today's Posts |
|
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to fill cells with a different kind of series? | Excel Worksheet Functions | |||
| Auto Fill Series issue... | Excel Discussion (Misc queries) | |||
| Auto Fill Series when number ends in -1 | Excel Discussion (Misc queries) | |||
| Fill series but a little different | Excel Discussion (Misc queries) | |||
| Excel should not automatically extend series or fill values | Excel Discussion (Misc queries) | |||
Hybrid Mode
