Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help

2014-07-21 Thread Vaibhav Joshi
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

Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help

2014-07-21 Thread Dileep Kumar
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

Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help

2014-07-21 Thread Paul Schreiner
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

Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help

2014-07-21 Thread Paul Schreiner
>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("'"

Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help

2014-07-21 Thread Paul Schreiner
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)

Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please Help

2014-07-22 Thread Dileep Kumar
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