Creating Forms.

[cos]

Hello everyone,

I'm a novice to XL (2004 Mac) and I am trying to create a form that
would do something rather complicated. It's hard to explain, but it
would be used to break down scenes in a movie. Every 8-1/2 x 11 page
would have five of these forms. Each form would have about 10 fields
in it and each field would have specific information about that scene.
(Scene no, date, time, set no., set name, action, notes etc.) There are
typically about 80 scenes in a two- hour movie so there would be
about 80 of these forms spread over about 20 pages. Now the tricky
part. Is there a way to get Excel to sort the forms out according to
different fields? Anotherwords, if I want to see the forms arranged in
order of scene no, or according to set no. or shooting date?

What is the best way to get proficient at creating forms?

Thank you.

Cos

 

[Bob Greenblatt]

Hello everyone,

I'm a novice to XL (2004 Mac) and I am trying to create a form that
would do something rather complicated. It's hard to explain, but it
would be used to break down scenes in a movie. Every 8-1/2 x 11 page
would have five of these forms. Each form would have about 10 fields
in it and each field would have specific information about that scene.
(Scene no, date, time, set no., set name, action, notes etc.) There are
typically about 80 scenes in a two- hour movie so there would be
about 80 of these forms spread over about 20 pages. Now the tricky
part. Is there a way to get Excel to sort the forms out according to
different fields? Anotherwords, if I want to see the forms arranged in
order of scene no, or according to set no. or shooting date?

What is the best way to get proficient at creating forms?

Thank you.

Cos

The way applications like this are normally done with Excel is to create a
table of data. Use a single worksheet with columns for all the information
you need like number, date, time, etc. then this can be sorted freely so
you can look at or organize it any way you want. The next step is to create
the printed form on another worksheet. You can easily organize this so that
the 5 items will fit on a page. Then a macro (or some clever formulas would
fill the form with data in the order appearing in the table.

Yet another way is to use Excel to collect and organize the data, and to
print the result in WORD. Create the output form in WORD and use the
mail-merge feature to populate and/or print the form.

 

[cos]

Bob,

How can I learn more about this? Thanks.

Cos

 

[Bob Greenblatt]

Bob,

How can I learn more about this? Thanks.

Cos

Well, I'm not sure. Try some of the current texts on Excel. They may have
some good examples for Windows Excel that ought to work fine. Or, hire a
consultant to help you.