what you are trying to achieve?
On Mon, Jul 21, 2014 at 5:12 PM, Dileep Kumar wrote:
> Dear Friends,
>
> Please find attached Daily Reporting Formate of Excel in the summary sheet
> I am unable to get the vales using indirect function.
>
> Please help me friends.
>
> --
> Regards,
> Dileep Kuma
Hi Vaibhav,
Thanks a lot for your reply. I found that what mistake I am doing.
Is there any way that we can give the reference of the date field in the
summary sheet science I have all the sheet with dates only.
That can much faster for me to finish out.
On Mon, Jul 21, 2014 at 5:45 PM, Vaibh
Kumar
>To: excel-macros@googlegroups.com
>Cc: Haseeb Avarakkan
>Sent: Monday, July 21, 2014 7:42 AM
>Subject: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help
>
>
>
>Dear Friends,
>
>
>Please find attached Daily Reporting Formate of Ex
>To: "excel-macros@googlegroups.com"
>Sent: Monday, July 21, 2014 8:35 AM
>Subject: Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please
>Help
>
>
>
> For your sumif(Indirect function in cell B5, try:
>
>=SUMIF(INDIRECT("'"
4 8:42 AM
>Subject: Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please
>Help
>
>
>
>By way of explanation:
>
>The Dates you have in column "A" are actually numbers.
>(the number of days since 1/1/1900)
>
>The sheet names are strings (of course)
Hi Vaibhav & Paul,
Thanks a lot for your HELP.
On Mon, Jul 21, 2014 at 6:18 PM, Vaibhav Joshi wrote:
> see this...
>
> Cheers!!
>
>
> On Mon, Jul 21, 2014 at 5:53 PM, Dileep Kumar wrote:
>
>> Hi Vaibhav,
>>
>> Thanks a lot for your reply. I found that what mistake I am doing.
>>
>> Is there a