I am trying to figure out a way to write a code that will select and copy
only those cells within a selected range that have data in them, and to
suppress those that are empty.

The information will eventually be "paste-special-ed" into a word document,
such that automatic updating is possible.

I'd appreciate any ideas anyone might have.

Thanks!