StevenData
New Member
- Joined
- Mar 23, 2002
- Messages
- 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
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