Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel fill series
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel fill series
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel fill series
The first part of you suggestion was perfect. Thank you. If I need to start
at say unit 1050 up 1200 consecutively how would I go about that? A macro? I've never used macro's. Thanks "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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel fill series
="1030 33rd st #"&ROW(A1050)
or for i = 1050 to 1200 ' 1 to 400 msgbox "1033 33rd St, #" & i next i -- Don Guillett SalesAid Software "FreezingInFargo" wrote in message ... The first part of you suggestion was perfect. Thank you. If I need to start at say unit 1050 up 1200 consecutively how would I go about that? A macro? I've never used macro's. Thanks "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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel 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? Don, How would I modify the formula to use it with letters, A thru M e.g., instead of apt. numbers? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Upper / Fill Series Function in Excel | Excel Discussion (Misc queries) | |||
Series equivalent in Excel 2000 | Charts and Charting in Excel | |||
The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
Excel should not automatically extend series or fill values | Excel Discussion (Misc queries) | |||
how do I change a line series to a column series in excel? | Charts and Charting in Excel |