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,

Hi,
in you summary sheet under day 1 enter

=1!c164

in day 2
=2!c164

etc


"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,

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,

Note: A3 needs .xls appended.

workbook1.xls


Gord

On Tue, 01 Sep 2009 09:21:57 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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,