Next j
End Sub
.r.karunanithi.
--- On Tue, 6/21/11, Subhash Yadav wrote:
From: Subhash Yadav
Subject: Re: $$Excel-Macros$$ solution to put data automtically
To: excel-macros@googlegroups.com
Date: Tuesday, June 21, 2011, 8:35 AM
Thanks a lot my friend
On Wed, Jun 8, 2011 at 10:
Please help me out.
Regards,
Subhash Yadav
On Wed, Jun 22, 2011 at 2:11 PM, Subhash Yadav wrote:
> No, this is daily entry sheet for fuel issued to equipments. This will
> continue for years.
>
>
> Regards,
>
>
> Subhash Yadav
>
> On Wed, Jun 22, 2011 at 6:16 AM, ashish koul wrote:
>
>> @IC
No, this is daily entry sheet for fuel issued to equipments. This will
continue for years.
Regards,
Subhash Yadav
On Wed, Jun 22, 2011 at 6:16 AM, ashish koul wrote:
> @ICWAI Help - subhash has already attached the file. please check the
> mail trail
>
> @subash - is there any fixed range
@ICWAI Help - subhash has already attached the file. please check the mail
trail
@subash - is there any fixed range where u will be adding the data if so
then you can easily use vlookup or add any new col and start marking new
values add with any text then you can use the lookp to get the value
HI Ashish ,
could you please attached the sheet with below formula how it works.
Thansk,
Rakesh.
On Tue, Jun 21, 2011 at 8:35 AM, Subhash Yadav wrote:
> Thanks a lot my friend
>
>
>
> On Wed, Jun 8, 2011 at 10:01 PM, ashish koul wrote:
>
>> issue = INDEX(E:E,SUMPRODUCT(MAX(($A$4:A10=A11)*R
Dear friend,
One more doubt. If we forget to put for any perticular date and we put later
on the date shoud come against the latest date and the asset code.
Sample is attached for your reference.
Regards,
Subhash Yadav
On Wed, Jun 8, 2011 at 10:01 PM, ashish koul wrote:
> issue = INDEX(E:
Thanks a lot my friend
On Wed, Jun 8, 2011 at 10:01 PM, ashish koul wrote:
> issue = INDEX(E:E,SUMPRODUCT(MAX(($A$4:A10=A11)*ROW($A$4:A10))),0)
>
> reading =INDEX(F:F,SUMPRODUCT(MAX(($A$4:A10=A11)*ROW($A$4:A10))),0)
>
>
> On Wed, Jun 8, 2011 at 7:03 PM, Subhash Yadav wrote:
>
>> Dear fri
issue = INDEX(E:E,SUMPRODUCT(MAX(($A$4:A10=A11)*ROW($A$4:A10))),0)
reading =INDEX(F:F,SUMPRODUCT(MAX(($A$4:A10=A11)*ROW($A$4:A10))),0)
On Wed, Jun 8, 2011 at 7:03 PM, Subhash Yadav wrote:
> Dear friends,
>
> I am having one sheet containing data for fuel issue.
>
> I want, if i put any asset c
Dear friends,
I am having one sheet containing data for fuel issue.
I want, if i put any asset code previous issue and previous reading should
come from the latest present issue and present reading of same asset.
In the attached sheet yellow cell date should come in yellow cell and
magenta cell
