Vlookup from series of tabs
Suppose Row 1 is with the dates in excel date format; the below formula will
pick the cell value c164 of the corresponding sheet. Sheets are numbered in
the format 1,2,3,..31.
=INDIRECT("'[workbook.xls]" & DAY(A$1) & "'!C164")
If this post helps click Yes
---------------
Jacob Skaria
"Kramer" wrote:
Hello,
I have a workbook which has worksheets for each day of the month (i.e. "1",
"2").
I would like to retreive the figure in cell C164 of each worksheets (i.e.
for each day of the month) on to another workbook. The other workbook where i
want the figure to show, i have the dates running horizontally at the top and
i want the figure in cell C164 of the other worksheet to show up in the
corresponding date in this workbook.
thanks,
|