Need formula to post data from one workbook to another workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top