Excel Question

[Dene Wilby]

Hi,

I'm asking this on behalf of someone so hopefully i'm in the right
place. Copied and pasted as follows:

I've inherited an Excel spreadsheet with 12 tab sheets: eg: January,
February, through to December. I would like to merge information from
the February tab sheet to a word document but when I try to select
'print area' it only reads 'entire spreadsheet'. How do I overcome this
and disregard any of the other 11 tab sheets?


Thanks for any help you can throw my way

Dene

 

[JE McGimpsey]

The "Entire Worksheet" (at least that's what it says for Word v.X and
Word2004) refers only to the sheet you have selected in the workbook.

You can override that by typing in the range to import from (e.g.,
A1:J100)

SpreIn article <[email protected]>,

 

[Dene Wilby]

The "Entire Worksheet" (at least that's what it says for Word v.X and
Word2004) refers only to the sheet you have selected in the workbook.

You can override that by typing in the range to import from (e.g.,
A1:J100)

Thanks the quick reply, i'll pass that info. on.

cheers

Dene