Here is the complete solution.
--- On Sat, 3/9/13, Shrinivas Shevde shrinivas...@gmail.com wrote:
From: Shrinivas Shevde shrinivas...@gmail.com
Subject: Re: $$Excel-Macros$$ Re: calculating between two cells in two
different sheets.
To: excel-macros@googlegroups.com
Date: Saturday, March 9,
Hi all,
How to find list of active filters in place in Excel.
Regards
Eugene
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise,
hi
are you looking for this
http://j-walk.com/ss/excel/usertips/tip044.htm
Regards
Ashish
On 3/9/13, Eugene Bernard eugene.bern...@gmail.com wrote:
Hi all,
How to find list of active filters in place in Excel.
Regards
Eugene
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Hi Negi,
It is not doing anything. Although it says task complete. All I want is
when I click button it should take the amount in Consumed sheet col.D row 2.
So it needs to search lot id for consumed amount in Main sheet and minus
that amount from Yield and put in Cl J of Main sheet.
Thanks
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
Try this formula see if it suffice ur requirement
*=HYPERLINK(#'B$1'!aMATCH($A2,INDIRECT('B$1'!$A:$A),0),Click)
*
Regards
Ashish
On Fri, Mar 8, 2013 at 12:52 AM, Renukachari Kasee jva.ch...@gmail.comwrote:
Dear experts,
please solve the attached problem for search option using VBA
please
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).Row).FillDown
End Sub