Vlookup using tabs

[Kramer]

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,

 

[Eduardo]

Hi,
in you summary sheet under day 1 enter

=1!c164

in day 2
=2!c164

etc

 

[RagDyeR]

Is the *other* workbook supposed to use those daily numbers when the "daily"
workbook is closed?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

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,

 

[Gord Dibben]

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

 

[Gord Dibben]

Note: A3 needs .xls appended.

workbook1.xls


Gord

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

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,