Help Looping form generation from spreadsheet list
 

Hello everybody,

I have a moderate understanding of excel and macro creation but
nothing to the level I believe I would need to do what I need. Once a
month I have to generate labels (in the form of a 1-page printout) for
a number of customers I have been filling them out by hand in the
past, but was wondering if it would be possible to make an excell
macro to do it for me. An independent file for each label by customer
must also be generated for my records.

My spreadsheet of itemized orders looks as follows

Name Pick Up Loc Delivery Loc Date Item
A A1 A2
A3 ItemA1
A A1 A2
A3 ItemA2
A A1 A2
A3 ItemA3
B B1 B2
B3 ItemB1

and so on, my list is well over 1000 rows. There is no limit or
pattern to the number of independent items an individual could have
ordered.

With my limited knowledge of programing, I would imagine something
like the following would need to take

place.

For (Spreadsheet) Do until no more data

For -NAME- Do until -NEW CONTENTS IN NAME-

Create a new form from file (Form template.xls);

Take all data cells and copy them into appropriate cells on a form
including name;

Copy each equipment into its own cell in a vertical sequence of
cells on the form;

Save the form to (Labels directory) as (*Name*.xls);

Close the form;

End

End

Can anyone help me with this? Is it even possible in excell?

Many thanks.

Ryan

Help Looping form generation from spreadsheet list
 

the code on this page at Ron de Bruin's site should get you started:

http://www.rondebruin.nl/copy5.htm

If I correctly understand your description.

--
Regards,
Tom Ogilvy



"JokerFrowns" wrote:

Hello everybody,

I have a moderate understanding of excel and macro creation but
nothing to the level I believe I would need to do what I need. Once a
month I have to generate labels (in the form of a 1-page printout) for
a number of customers I have been filling them out by hand in the
past, but was wondering if it would be possible to make an excell
macro to do it for me. An independent file for each label by customer
must also be generated for my records.

My spreadsheet of itemized orders looks as follows

Name Pick Up Loc Delivery Loc Date Item
A A1 A2
A3 ItemA1
A A1 A2
A3 ItemA2
A A1 A2
A3 ItemA3
B B1 B2
B3 ItemB1

and so on, my list is well over 1000 rows. There is no limit or
pattern to the number of independent items an individual could have
ordered.

With my limited knowledge of programing, I would imagine something
like the following would need to take

place.

For (Spreadsheet) Do until no more data

For -NAME- Do until -NEW CONTENTS IN NAME-

Create a new form from file (Form template.xls);

Take all data cells and copy them into appropriate cells on a form
including name;

Copy each equipment into its own cell in a vertical sequence of
cells on the form;

Save the form to (Labels directory) as (*Name*.xls);

Close the form;

End

End

Can anyone help me with this? Is it even possible in excell?

Many thanks.

Ryan