Programmatically Possible??

[Suzanne]

Instead of sending Excel data to a Word 'Directory' Merge, I'm setting up a
form within Excel to capture data in the appropriate form format. I would
really like to avoid having to physically create 200 blocks (1500+ rows) to
capture data that may or may not be there.

1) Is there any way to programmatically set up this form so that if there
is data on the source worksheet, the form will populate on its own?

2) If #1 is not possible, some method that tells Excel to copy the block of
information and/or update the source to the appropriate (next) row would
really be helpful.

Source Worksheet: Hazard Data
Form Worksheet: Hazard Form

Hazard Form!A1:Q4 = form header

Hazard Form!C5 = Hazard Data!H2
Hazard Form!F5 = Hazard Data!I2
Hazard Form!P5 = Hazard Data!B2
Hazard Form!B8 = IF(Hazard Data!M2<>"", Hazard Data!M2, Hazard Data!Q2)
Hazard Form!B10 = IF(Hazard Data!L2<>"", Hazard Data!L2, Hazard
Data!O2)Hazard Form!B12 = Hazard Data!S2

The next block with Hazard Data!B3:Q3 begins on Hazard Form!B14
The next block with Hazard Data!B4:Q4 begins on Hazard Form!B23
and so on...

I'm not holding out much hope that this is possible, but wanted to shout out
in the event that someone might have run across something similar.

Thanks -- Suzanne

 

[Tim Williams]

When you say "capture data in the appropriate form format" do you mean you
want to display data which is currently in a tabular format on a separate
sheet which is formatted as a series of forms? It's not clear whether the
form is for data entry or not.

Tim