you for bearing with me.
Jaz
On Saturday, March 9, 2013 2:31:31 AM UTC-8, Ravinder Negi wrote:
>
> Here is the complete solution.
>
> --- On *Sat, 3/9/13, Shrinivas Shevde >*wrote:
>
>
> From: Shrinivas Shevde >
> Subject: Re: $$Excel-Macros$$ Re: calculating between
Hi Ashish,
Thanks for the help. I do not want to loop this. In real time it would be
only one lot at a time. Also the sample sheet contains identical lot list,
whereas in my real sheet the main sheet has ~3000 entries. So the macro
should look only for one lot at a time. This lot will be st
HI try this
Sub sample()
Dim i As Long
Sheets("Main").Range("j2:j" &
Sheets("Main").Range("a1048576").End(xlUp).Row).ClearContents
Sheets("Main").Range("j2").Formula =
"=I2-VLOOKUP(Main!B2,Consumed!B2:D25,3,0)"
Sheets("Main").Range("j2:j" &
Sheets("Main").Range("a1048576").End(xlUp
HI Shrini,
I would appreciate if you can put this in a macro. It is doing exactly
what I like.
Thanks for helping.
Jaz
On Thursday, March 7, 2013 1:00:57 PM UTC-8, Jaz wrote:
>
> Hello all,
> I am wondering if I can be helped in this. I have two sheets 'Main' &
> 'Consumed' B col. of both
Negi for helping.
Jaz
On Saturday, March 9, 2013 2:31:31 AM UTC-8, Ravinder Negi wrote:
>
> Here is the complete solution.
>
> --- On *Sat, 3/9/13, Shrinivas Shevde >*wrote:
>
>
> From: Shrinivas Shevde >
> Subject: Re: $$Excel-Macros$$ Re: calculating between two ce
Here is the complete solution.
--- On Sat, 3/9/13, Shrinivas Shevde wrote:
From: Shrinivas Shevde
Subject: Re: $$Excel-Macros$$ Re: calculating between two cells in two
different sheets.
To: excel-macros@googlegroups.com
Date: Saturday, March 9, 2013, 12:33 PM
On Sat, Mar 9, 2013 at 12:32
On Sat, Mar 9, 2013 at 12:32 PM, Shrinivas Shevde wrote:
>
>
> On Sat, Mar 9, 2013 at 11:52 AM, ravinder negi wrote:
>
>> there is no sheet
>>
>> --- On *Fri, 3/8/13, Jaz * wrote:
>>
>>
>> From: Jaz
>> Subject: $$Excel-Macros$$ Re: calculati
On Sat, Mar 9, 2013 at 11:52 AM, ravinder negi wrote:
> there is no sheet
>
> --- On *Fri, 3/8/13, Jaz * wrote:
>
>
> From: Jaz
> Subject: $$Excel-Macros$$ Re: calculating between two cells in two
> different sheets.
> To: excel-macros@googlegroups.com
> Date: F
there is no sheet
--- On Fri, 3/8/13, Jaz wrote:
From: Jaz
Subject: $$Excel-Macros$$ Re: calculating between two cells in two different
sheets.
To: excel-macros@googlegroups.com
Date: Friday, March 8, 2013, 10:20 PM
Hi,
I would appreciate very much if someone can help me on this.
Thank you
I already replied please check
On Fri, Mar 8, 2013 at 10:20 PM, Jaz wrote:
> Hi,
> I would appreciate very much if someone can help me on this.
> Thank you
> Jaz
>
> On Thursday, March 7, 2013 1:00:57 PM UTC-8, Jaz wrote:
>>
>> Hello all,
>> I am wondering if I can be helped in this. I have two
Hi,
I would appreciate very much if someone can help me on this.
Thank you
Jaz
On Thursday, March 7, 2013 1:00:57 PM UTC-8, Jaz wrote:
>
> Hello all,
> I am wondering if I can be helped in this. I have two sheets 'Main' &
> 'Consumed' B col. of both sheets have Lot ID.
> A macro should be writt
11 matches
Mail list logo