A Macro for creating semi-series

StevenData · Apr 13th, 2002, 03:31 PM

Greetings,
I would like to thank you in advance for taking your time and reading this post.
Problem:
I am trying to write a macro in excel that generates a series, e.g. from 1 to 100 and attaches them to a fixed alphanumeric prefix with a dash separating the two, e.g. : (note: Fill does not do it)

N180-1
N180-2
N180-3
…
N180-100

I would then like to export these generated smi-series to a full page of labels in Microsoft word. Each label in that page gets one of the items generated by excel. e.g.:

each label looks like the following:

First label:
Number: N180-1
weight: 2KG
Description: …..

Second label:
Number: N180-1
weight: 2KG
Description: …..

etceteras…

I appreciate your feedback and comments on this. Thank you.
Sincerely,
Steve

daleyman · Apr 13th, 2002, 03:42 PM

You can do this with a simple formula...

In the first column put the values

1
2
3
4
etc...

Then in the second column put the equation

="N180-" & A2 <<

daleyman · Apr 13th, 2002, 04:04 PM

buggy thing cut half my reply off.

anyhow, put value 1 in cell a2, and in cell b2 put

="180N-" & A2

...then fill down and copy to values.

nisht · Apr 14th, 2002, 12:49 AM

This what i have exactly shown in my example file no 14 'numbering'

http://www.pexcel.com/download.htm

i hope it will be useful to you.

if you any problem write back to me.

nishith desai
http://www.pexcel.com

StevenData · Apr 20th, 2002, 03:01 PM

Thank you everyone for the feedbacks.
Sincerely,
Steve

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 13th, 2002, 03:31 PM	#1
StevenData New Member Join Date: Mar 2002 Posts: 10	Greetings, I would like to thank you in advance for taking your time and reading this post. Problem: I am trying to write a macro in excel that generates a series, e.g. from 1 to 100 and attaches them to a fixed alphanumeric prefix with a dash separating the two, e.g. : (note: Fill does not do it) N180-1 N180-2 N180-3 … N180-100 I would then like to export these generated smi-series to a full page of labels in Microsoft word. Each label in that page gets one of the items generated by excel. e.g.: each label looks like the following: First label: Number: N180-1 weight: 2KG Description: ….. Second label: Number: N180-1 weight: 2KG Description: ….. etceteras… I appreciate your feedback and comments on this. Thank you. Sincerely, Steve

Apr 13th, 2002, 03:42 PM	#2
daleyman Board Regular Join Date: Mar 2002 Location: London, UK Posts: 167	You can do this with a simple formula... In the first column put the values 1 2 3 4 etc... Then in the second column put the equation ="N180-" & A2 <<

Apr 13th, 2002, 04:04 PM	#3
daleyman Board Regular Join Date: Mar 2002 Location: London, UK Posts: 167	buggy thing cut half my reply off. anyhow, put value 1 in cell a2, and in cell b2 put ="180N-" & A2 ...then fill down and copy to values.

Apr 14th, 2002, 12:49 AM	#4
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	This what i have exactly shown in my example file no 14 'numbering' http://www.pexcel.com/download.htm i hope it will be useful to you. if you any problem write back to me. nishith desai http://www.pexcel.com

Apr 20th, 2002, 03:01 PM	#5
StevenData New Member Join Date: Mar 2002 Posts: 10	Thank you everyone for the feedbacks. Sincerely, Steve