Need formula to post data from one workbook to another workbook

I would like to be able to have data from a number of
workbooks entered automatically into another workbook that
has several worksheets. The data from other workbooks
need to be entered automatically into various worksheets
in the other workbook.

I know that the formula =worksheet name!cell reference
can transfer data from one worksheet to another in the
same workbook, but I need to know the formula to get the
data from another workbook into a particular worksheet in
another workbook.

I hope someone in the newsgroup has the formula or can
direct me to a page in the Excel manual for help on this
subject.

Thank you

the formula you need is as follows

='[workbookname.xls]sheetname'!$C$22

change workbookname to the name of your workbook and sheetname to the
name of the sheet

Randall


On Wed, 5 Nov 2003 11:04:40 -0800,
wrote:

I would like to be able to have data from a number of
workbooks entered automatically into another workbook that
has several worksheets. The data from other workbooks
need to be entered automatically into various worksheets
in the other workbook.

I know that the formula =worksheet name!cell reference
can transfer data from one worksheet to another in the
same workbook, but I need to know the formula to get the
data from another workbook into a particular worksheet in
another workbook.

I hope someone in the newsgroup has the formula or can
direct me to a page in the Excel manual for help on this
subject.

Thank you