Merging certain cells from Excel to Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CMB - 15 Jun 2004 19:49 GMT

I have someone that needs to be able to move certain cell
information from an Excel worksheet to a Word document.
When she tries to select the specific cells, for example,
she's prompted for the range from the data source, she
enters the number of each cell but it pulls ALL cell
information not just for the specific cells she requested.

Anyone have any ideas?

Thank you in advance.

Reply to this Message

Cindy M -WordMVP- - 16 Jun 2004 18:05 GMT

Hi Cmb,

> I have someone that needs to be able to move certain cell
> information from an Excel worksheet to a Word document.
> When she tries to select the specific cells, for example,
> she's prompted for the range from the data source, she
> enters the number of each cell but it pulls ALL cell
> information not just for the specific cells she requested.

She should open the workbook in Excel, select and copy the
cell(s) she needs, then paste into Word.

If she needs a link, then Edit/Paste Special, activate the
"link" checkbox and choose the format that works best for
the individual case.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

:-)

Reply to this Message

- 16 Jun 2004 19:08 GMT

Hi Cindy,

Thanks for responding. We were hoping to avoid doing the
cut and paste thing...we did find a way to concatenate
some fields to take one less step out of the process.

Thanks again. I appreciate the help.

Celeste

>-----Original Message-----
>Hi Cmb,
[quoted text clipped - 24 lines]
>
>.

Reply to this Message

Cindy M -WordMVP- - 17 Jun 2004 15:38 GMT

> We were hoping to avoid doing the
> cut and paste thing...

Not CUT and paste; copy and paste. In my experience, that's
usually faster than going over an Insert menu, then
navigating to a document, etc.

If you really want to speed things up for the user, then
I'd go the route of a macro, where all she needs to do is
type in the range name she wants. The macro can then take
care of all the inserting part.

And I'd do that by creating a LINK field (same as
Edit/Paste Special).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

:-)

Reply to this Message