In A3 of a Sheet in workbook2 enter the name of workbook1

In A2 enter this formula

=INDIRECT("["&$A$3&"]" & COLUMN()&"!" & "$C$164")

Drag/copy across 31 columns.


Gord Dibben MS Excel MVP


On Tue, 1 Sep 2009 08:21:02 -0700, Kramer
wrote:

Hello,

I have a workbook with worksheets for each day of the month labeled "1",
"2".."31" etc. In each worksheet i would like to pull the figure in cell C164
of each sheet into another workbook. In the another workbook i have dates
from 1-31st running horizontally at the top. I would like the figure in cell
C164 for each day to show up in the second workbook under it's correct date.

thanks,