Re: $$Excel-Macros$$ Re: calculating between two cells in two different sheets.

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

Re: $$Excel-Macros$$ please solve the search the particular name on the other sheet PFA

Try this formula see if it suffice ur requirement *=HYPERLINK("#'"&B$1&"'!a"&MATCH($A2,INDIRECT("'"&B$1&"'!$A:$A"),0),"Click") * Regards Ashish On Fri, Mar 8, 2013 at 12:52 AM, Renukachari Kasee wrote: > Dear experts, > please solve the attached problem for search option using VBA > please look

$$Excel-Macros$$ Re: calculating between two cells in two different sheets.

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

Re: $$Excel-Macros$$ Re: calculating between two cells in two different sheets.

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 Neg

Re: $$Excel-Macros$$ Active Filters

Yeah Thanks a lot. Regards Eugene On Sat, Mar 9, 2013 at 10:36 PM, ashish koul wrote: > hi > are you looking for this > http://j-walk.com/ss/excel/usertips/tip044.htm > > Regards > Ashish > > On 3/9/13, Eugene Bernard wrote: > > Hi all, > > > > How to find list of active filters in place

Re: $$Excel-Macros$$ Active Filters

hi are you looking for this http://j-walk.com/ss/excel/usertips/tip044.htm Regards Ashish On 3/9/13, Eugene Bernard 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 wanna be? It’s >

$$Excel-Macros$$ Active Filters

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, accur

Re: $$Excel-Macros$$ Re: calculating between two cells in two different sheets.

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 P