pls add my number 9769855615 Anil Gawli
On Mon, Aug 8, 2016 at 9:43 PM, Rajeev Ranjan <06raj...@gmail.com> wrote:
> please add the my number 9811503853
>
> On Friday, 5 August 2016 14:16:39 UTC+5:30, Prabhu Pinky wrote:
>>
>> Creating WhatsApp group for VBA macro...
dear Ronsmithcan,
use below formula
=VLOOKUP(CLEAN(SUBSTITUTE(B3,CHAR(160),CHAR(17))),E:F,2,FALSE)
Regards,
Gawli Anil
On Sun, May 22, 2016 at 4:21 PM, Bill Q wrote:
> Hi,
>
> PSA.
>
> Trying to do a simple vlookup. I cleaned up the data by trimming, but
> still cannot get a match.
>
> I manua
yes
On Tue, Mar 15, 2016 at 3:53 PM, Pramod Singh wrote:
> Bro have u knowledge of Excel automation?
>
> Pramod
> On 15 Mar 2016 14:24, "Anil Gawli" wrote:
>
>>
>>
>> On Tue, Mar 15, 2016 at 1:08 PM, Pramod Singh
>> wrote:
>>
>&g
On Tue, Mar 15, 2016 at 1:08 PM, Pramod Singh wrote:
> This is notify to all guys who have good knowledge of VBA programming.
> I have un Opning for the post of Vba developer.
>
> Please contact me on below mention details if any one interested.
>
> Profile Vba developer
> Location Gurgaon
> Cont
Dear Nilkanth,
Pls find attached ... is this wht u wr searching?
Regards,
Anil.
On Sat, Feb 6, 2016 at 1:23 PM, Nilkanth Raval
wrote:
> Dear VBA Exoerts,
>
> Can u please help me in getting Text value in Pivot value field.
>
> Thanks,
> Nilkanth Raval
>
> Sent with AquaMail for Android
> htt
pls share the work sheet
On Wed, Oct 7, 2015 at 3:27 PM, abhishek bhalla <
bhalla_abhis...@rediffmail.com> wrote:
> Hi all,
>
>
>
> I want to combine data from different cells into a single. For example:
>
>
>
> A apple
>
> A ant
>
> A antique
>
> B bat
>
> B big
>
>
>
> I would like to collate d
Dear ,
Pl share the workbook with us
On Fri, Jul 31, 2015 at 2:02 AM, Rob Flott wrote:
> Why does my sheet tab calculate if there are no formulas on the tab, or
> even on the workbook?
>
> I am using Excel 2010 and my workbook has 3 tabs; each with about 3400
> rows and about 30 columns of data
Dear Nasir,
You need to share with specific people by specifying with their username
On Wed, Mar 18, 2015 at 3:51 PM, Nasir Saikh wrote:
> Anybody Can help me out on this
>
> On Wednesday, March 18, 2015 at 1:46:59 PM UTC+5:30, Nasir Saikh wrote:
>>
>> Hi,
>>
>> I need help to make a excel work
Dear Sir,
Pl find attached herewith my latest resume for your ref.
Warm Regards,
Gawli Anil.
On Tue, Mar 17, 2015 at 10:56 AM, Neelu Rawat
wrote:
> We are looking to hire folks who love Microsoft Excel for Team Lead and
> Business Analyst roles. We don't mind the kind of experience you have as
Dear Faisal,
Can u pls elborate more detail? I unable to understand your requirement.
Regards,
Gawli Anil
On Sat, Mar 14, 2015 at 3:34 PM, Faisal Pk wrote:
> Can anybody help me with a solution.
>
> Regards,
> Faisal PK
>
> On Fri, Mar 13, 2015 at 11:04 AM, Faisal Pk wrote:
>
>> I have the b
Dear Gaurav,
Thisworkbook and activeworkbook is same when comes to work but the
difference is thisworkbook will work where the code is written and
activeworkbook will work with active file
On Mon, Mar 9, 2015 at 3:51 PM, Gaurav Devrani
wrote:
> Hi,
>
> I tried working on that.. while I was test
Dear Gaurav,
Pls share the file
regards,
Anil
On Tue, Feb 3, 2015 at 10:25 AM, Gaurav Devrani wrote:
> Can anyone help me on this? I have a specific data and want to send that
> data to multiple recipients (have around 50 emails) but when i run my macro.
> It sends them individually instead of
Dear Sir,
Pl find attached herewith my resume for the same.
Regards,
Gawli Anil.
On Wed, Jan 7, 2015 at 9:53 PM, Mazhar Khan wrote:
> Hello Associate,
>
>
>
> I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of
> our client for My SQL DBA . Atlanta, GA. Please find below
Dear Mr. Ashu,
Pls find attached as per you requirement.
P.S pls change the address of the attachment as you req.
.Add ("T:\Commercial\Common\Shailendra\Data" & Format(Now(),
"mm-dd-yy") & ".xls")
Warm regards,
Gawli Anil.
On Wed, Jan 7, 2015 at 1:24 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
>
Dear Friends,
A very happy New Year to you and your family.
Regards,
Gawli Anil.
On Thu, Jan 1, 2015 at 9:49 PM, Eugene Bernard wrote:
> Hi all,
>
> Happy new year to you all.
>
> Regards
> Eugene
>
> On Wed, Dec 31, 2014 at 7:54 PM, Vaibhav Joshi wrote:
>>
>> Joyous January –Fabulous February
Dear Amar,
PFA.
Regards,
Gawli Anil.
On Fri, Dec 26, 2014 at 10:30 AM, amar takale wrote:
> Dear Vaibhav
>
> I required output M & N column (Grey shaded Cell).
>
> Regards
> Amar
>
> On Thu, Dec 25, 2014 at 11:04 PM, Vaibhav Joshi wrote:
>> Hi from where you are arriving target price?
>>
>> ++
Dear Rockernayal,
Pls share a workbook with us.
Regards,
Gawli Anil
On Mon, Dec 22, 2014 at 3:15 PM, Mandeep Baluja wrote:
> Please explain your Query Again I an unable to understand it . Aeging can be
> count but on what criteria whether on particular order no, material no ,
> document no. whe
Pl share the workbook with us
On Thu, Nov 27, 2014 at 2:56 PM, Shrinivas Shevde
wrote:
> Dear All
> Please find below macro.
> Previously it was running very fine but from last few days it takes time (2
> to 3 min).I could not trace out can any one help me for finding out
> problem.
>
> Macro is
Dear Laxmanan,
attachment is not there
On Tue, Nov 25, 2014 at 12:32 PM, Laxmanan M wrote:
> can any one pls?
> On Monday, November 24, 2014 7:44:09 PM UTC+5:30, Laxmanan M wrote:
>>
>> Hi All,
>>
>> I have done with the macro code for the Vendor file validation.But i need
>> to make some amen
Dear Mr. Ladmanan,
Pls do send an attachment.
Warm Regards,
Gawli Anil
On Thu, Nov 20, 2014 at 11:53 PM, Laxmanan M wrote:
> Am not gud at macros and am in learning phase.But i have been assigned to
> complete this task.So am roaming around the web.Please paul help me to be
> done this macro co
Dear Rupesh,
Pls share the file.
Warm Regards,
Gawli Anil.
On Thu, Oct 9, 2014 at 1:50 PM, Rupesh Patil wrote:
> Hello Expert,
>
> In my organization we have developed VBA Application for doctors. now we
> want to create .exe file of this application
> so as per my knowledge we can't create .ex
Dear Hilary,
Pl find attached as required by you
Warm Regards,
Gawli Anil :)
On Wed, Oct 1, 2014 at 3:10 PM, Hilary Lomotey wrote:
> Hello experts,
>
> kindly assist with code in the form attached.
> what i need to do is that when i open the userform, i want to select names
> on the left listb
Dear Chandrashekar,
Cells should not be empty. Append 0 and see .
Warm Regards,
Gawli Anil
On Fri, Sep 12, 2014 at 12:19 PM, Chandra Shekar
wrote:
> Hello Vaibhv,
>
> It seems formula is wrong count should be 4 but its giving as 7. Could you
> please check it.
>
> Thanks in advance.
>
> Regard
Dear Rupesh,
Write below code in a module.
Dim b As String
ActiveSheet.Name = b
Activesheet.SaveAs Filename:="C:\HarshadMacro\" & b & ".xlsx"
Workbooks(b & ".xlsx").Close
On Thu, Sep 11, 2014 at 12:05 PM, Rupesh Patil
wrote:
> Hello Expert,
>
> I need your help.
> I need VBA Macro.
> How to s
Dear Jones,
Pls share the worksheet with us, we'll do it as much we can do it..
Warm Regards,
Gawli Anil :)
On Tue, Sep 2, 2014 at 2:05 PM, Jones George wrote:
> Hi All,
>
> I need an urgent help. I have to send a mass mailer to approx 10k email
> addresses. The task at hand is that I have to
Dear Hilary,
Pl find below attached file for you ref.
Warm Regards,
Gawli Anil.
On Mon, Sep 1, 2014 at 9:16 PM, Hilary Lomotey wrote:
> Hello Experts
>
> Just found a temporal solution to my question above however, i wish to
> have some modification, i managed to get the code below but i mod
Dear Rjag,
First of all save that code excel file as .xlsm format then run the code it
should work properly.
if found any error then pls let me know.
Warm Regards,
Gawli Anil.
On Tue, Aug 26, 2014 at 7:45 AM, rich johnson wrote:
> Well Paul there's a guy in England who says this formula wor
On Tue, Jul 29, 2014 at 1:48 AM, Gary . wrote:
> Please respond to gurjant.si...@damcosoft.com
>
> *Position: Developer (MYSQL)*
>
> *Location: Reston, VA*
>
> *Type: Contract/ FULL TIME*
>
>
>
> JD:
>
> We need to look for strong developer (MySql) – with hands-on experience in
> designing Db
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> -
>
> From: Anil Gawli
> To: "excel-macros@googlegroups.com" ;
Dear Ankur,
Pl share the workbook with us.
Warm Regards,
Gawli Anil.
On Fri, Jun 20, 2014 at 10:36 AM, Ankur Gupta wrote:
> I am new to excel and absolutely a novice to vb. I have been given a task to
> write macros code in vba in excel. The macro code is already there but
> nobody knows the pa
Dear Daniel,
Pl share a workbook with us.
Warm Regards,
Gawli Anil
On Fri, May 30, 2014 at 1:32 PM, Kof Bar wrote:
> Hi,
>
> I would like to create a macro that will format all cells in a worksheet to
> accounting format:
>
> _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)
>
> except cells con
Dear Praful,
Why u are using sumproduct u can use averageif formula.
=averageif(range,criteria,criteriarange).
Warm Regards,
Gawli Anil.
On Wed, Mar 12, 2014 at 5:36 PM, Prafull Jadhav
wrote:
> Dear All,
> Good Evening ,
>
> 1)I am not able to calculate the Average Resolution time with the he
Dear Praful,
Pl find the modified file as req.
Warm Regards,
Gawli Anil
On Wed, Feb 26, 2014 at 5:18 PM, Prafull Jadhav
wrote:
> Dear Ravinder Sir,
> Thanks for Reply..it is working fine.
>
> Can we make the same without selecting Range and paste range(Without message
> box)?
> Means we need no
Dear Hilary,
U have to release the earlier filter i.e clear filter criteria and
then apply the fresh one.
Warm Regards,
Gawli Anil.
On Thu, Feb 27, 2014 at 9:06 AM, mrExcel4u wrote:
> Plz share your workbook
>
> Thanks & regards,
>
> www.MrExcel4U.com
>
>
> On Thu, Feb 27, 2014 at 2:06 AM, Hil
Dear Maria,
Pl share the workbook with us.
Warm Regards,
Gawli Anil.
On Tue, Feb 25, 2014 at 2:54 PM, MH wrote:
>
> Hello,
>
> The following code fills the column till the last row in excel, i dont want
> to do this.
> I want the formula till lets say column A's last filled index (e.g. till 6
Dear Shankar,
Pl find attached.
Warm Regards,
Gawli Anil.
On Mon, Feb 10, 2014 at 2:27 PM, Shankar Bheema wrote:
> Dear all,
>
> I attached an excel workbook which contains 3 worksheets. worksheet1 is
> named as Members worksheet2 is with membername and worksheet 3 is also named
> after the me
Dear Fonbery,
Pl share the workbook with us.
Warm Regards,
Gawli Anil/.
On Thu, Jan 23, 2014 at 7:45 PM, Berinyuy Fonyuy wrote:
> Dear reader, I got an excel sheet of 44 indicators, with Health data that
> has been conditioned with a red pop up sign to show that the an indicator is
> not well
Dear Rupesh,
Kindly share the workbook with us.
Warm Regards,
Gawli Anil
On Thu, Jan 2, 2014 at 1:37 PM, Rupesh Patil wrote:
> Hi expert
>
> Please look below code and tell me why I am getting this error(Mentions in
> subject line)
> Private Sub ComboBox1_Click()
> Select Case ComboBox1
Dear Rupesh,
put $ sign in between the ranges
like this
=VLOOKUP(K2,$A$2:$K$494,6,FALSE) it will work
Warm Regards,
Gawli Anil
On Thu, Dec 19, 2013 at 1:54 PM, Rupesh Patil
wrote:
> Hi Experts,
>
> =VLOOKUP(K2,A2:K494,6,FALSE)
>
> Can any one suggest me, what is wrong with above formula
>
Dear Chandrashekar,
Pl share the sample data.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Fri, Nov 15, 2013 at 2:13 PM, Chandra Shekar
wrote:
> Hello,
>
> How to get count of visible cells in Pivot tables where as bel
Dear rajan,
Pl elaborate more on this query
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Thu, Nov 14, 2013 at 11:57 AM, Rajan sharma
wrote:
> Dear all experts,
>
> Is my query is valid ? can we lookup the closes
Dear Harish,
Pl find attached herewith the solution.
Warm Regards,
Gawli Anil.
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Mon, Nov 11, 2013 at 2:37 PM, Harish P Y wrote:
>
> Hi Vinay,
>
> In the location wise work sheet when i select the locat
Dear Ganesh,
Pl see the attached sheet.
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Fri, Oct 25, 2013 at 12:05 PM, Ganesh N wrote:
> Hi Team,
>
> I am learning macros. I have run macro to lookup 2 Employee ID list. But
> that is limited if the
Application.SendKeys ("vlookup")
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Fri, Oct 18, 2013 at 4:37 PM, dr wrote:
> Would anyone know how to change or control where the vlookup window opens in
> code?
>
> On Tuesday, October 15, 2013 9:52:24 AM
Dear Jocky,
Kindly unlock the password and resend.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Thu, Oct 17, 2013 at 1:59 PM, Jocky Beta wrote:
> Hi Team,
>
> Can anybody fix this attached error for me. i am also attachi
Dear Amresh kushwaha
U can use vlooup is these
=VLOOKUP(B8,H3:J8,3,0)&A8
On Mon, Jul 23, 2012 at 1:52 PM, Amresh Maurya <> wrote:
> Hi ,
>
> I have attached a function for you kindly add it in your add-ins and use.
>
> Function perfix(Outlet As String, Level As String, numbner As Integer)
>
> If
dear Vijay
Transpose is done only in same file not in another file.
first of all copy the source data.
Then Paste it in another file and then from there transpose it.
Regards,
Gawli Anil
On Mon, Jul 23, 2012 at 6:51 AM, P.VIJAYKUMAR <> wrote:
> Dear Excel Experts,
>
> When I try to paste special
Pl share u r excel sheet to make us clear...
Regards,
Gawli Anil
On Tue, Jul 17, 2012 at 11:39 AM, NOORAIN ANSARI
wrote:
> Dear Hanumant,
>
> Please share your workbook with group.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> --
ease
>>>>> help me dear. Sorry to trouble u again and again.
>>>>>
>>>>>
>>>>>
>>>>> On Mon, Jul 16, 2012 at 5:30 PM, NOORAIN ANSARI <
>>>>> noorain.ans...@gmail.com> wrote:
>>>>>
>>>>
Pls find Attached sheet ...Like this u want?
Regards,
Gawli Anil
On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay wrote:
> Hi Friends,
>
> I need your help to solve my PT Problem.
> The description is given in sheet itself. Please FA.
>
> Thanks.
>
> --
> With regards,
>
> MaNgEsH
>
> --
> FORUM
if your system doesn't support Date Time picker then install it through
> below link
>
>
>
>
>
>
>
>
>
>
> http://danielcurran.com/instructions/how-to-install-microsoft-date-time-
> picker-control-60-sp4/
>
>
> On Mon, Jul 16, 2012 at 3:16 PM, An
dear noorian
How u add the Dt picker in user form... pls let me know..
Regards
Gawli Anil
On Mon, Jul 16, 2012 at 3:04 PM, NOORAIN ANSARI wrote:
> Dear DS,
>
> Please try it..
>
> *Private Sub CommandButton1_Click()
> Dim i As Integer
> Dim dt As Date
> i = Cells(Rows.Count, "A").End(xlUp).Row
Dear Dhartikumar
Pls share us with some data.
Regards,
Gawli Anil
On Mon, Jul 16, 2012 at 12:46 PM, Dhartikumar Sahu <> wrote:
> awaiting for reply..
>
>
> -- Forwarded message --
> From: Dhartikumar Sahu
> Date: Mon, Jul 16, 2012 at 10:18 AM
> Subject: $$Excel-Macros$
Dear Sunnie
Uncheck R1c1 check box from file-Options-Formula.
Hope it should work
Regards,
Gawli Anil
On Fri, Jul 13, 2012 at 8:20 AM, Susan 1 <> wrote:
> Attached are the two spreadsheets. The one titled Aug2012 has the R1C1
> formula, the file ETS2011, is the data template for this year's en
Show us a sample format.
For Idea.
Thanks & Regards,
Gawli Anil
On Wed, Jul 11, 2012 at 3:30 PM, Priti_Verma < wrote:
> * *
>
> *Hi,*
>
> *To all,*
>
> *I am new here,please help me ,to find out all details about the country
> ,which is selected by drop down list.*
>
> *See the attached file.*
heartly congrats Mr Rajan..:)
Regards,
Gawli Anil.
On Thu, Jul 5, 2012 at 8:32 AM, Raghav wrote:
> Congratulations Rajan.
>
> ** **
>
> Regards,
>
> Raghav
>
> Sr. Analyst
>
> Tata Teleservices Ltd.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> exce
your formula is right but u have protected the some sheet that's why it's
not picking the value.
for eg.
17-jul 2012 sheet the amount invested field is not protected that's why
value is a capturing but in case of 24jul 2012 same field is not capturing
because it is been protected .
Regards
Gawli A
Dear Vijay,
For this you may use conditional formatting. There is no need to make macro.
Thanks & Regards,
Gawli Anil
On Wed, Jul 4, 2012 at 11:00 AM, vijay yadav <> wrote:
> Hi Members / Experts
>
> I need a macro to change the background color of a cell as soon as i
> change the value (alph
oving all the
> punctuation mark at a time with code and without userform help ?
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
>
>
>
> On Wed, Jun 27, 2012 at 3:36 PM, Anil Gawli wrote:
>
>> sorry for wrong attachment
>> just see this attach
dear Sharath
Pl share u r data with us...
Regards,
Gawli Anil
On Wed, Jun 27, 2012 at 3:21 PM, sharath chandra <
sharath.c.sambr...@gmail.com> wrote:
>
> Hello Experts,
>
> I need a quick VBA code. We have column where we enter a name in "First
> Name Last Name" format. When someone enters a name
pls find attached sheet
On Wed, Jun 27, 2012 at 2:52 PM, Deba Ranjan wrote:
> Sir,
>
> PFAand there are lots of punctuation which need to be clean.
>
> For cleaning and trimming the sheets i have used the code below mention
> and it is fine working:-
>
>
> Sub TrimCleanCells()
> Dim Rng
select the column & press Ctlr+g and go to blank and then press Alt+E D and
select row and delete .
Regards,
Gawli Anil
On Tue, Jun 26, 2012 at 11:34 AM, Prince Dubey wrote:
> Hi Smitha,
>
> Please use this Macro hope this help you.
>
> Public Sub DeleteBlankCols(strSheetName As String, strRange
Pls find attached sheet FY Ref.
On Mon, Jun 25, 2012 at 12:13 PM, सुनिता पौडेल wrote:
> Dear all,
>
> It has always been previlege to query on this group whenever needed and
> thanks from heart.
>
> I need one help regarding finding out maximum number and their name in one
> cell ?
>
> Have a won
Hi Krishna,
Thanks 4 sharing ...
Regards,
Gawli Anil
On Wed, Jun 20, 2012 at 8:35 PM, NOORAIN ANSARI wrote:
> Nice collection, Kirshna
>
> Thanks to sharing with group.
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Wed, Jun 20
It is just on pressing the button on Keyboard the condition runs
eg..
Application.onkey"{F2}","Hi You Pressed F2 function button"
it shows the message
Regards,
Gawli Anil
On Fri, Jun 15, 2012 at 5:28 PM, Hemant wrote:
> Hi Group,
>
> Pls explain,
>
> What is Application.OnKey, Application.OnTim
Yes that is created by data validation
Ahmed is Right.
Regards,
Gawli Anil
On Fri, Jun 15, 2012 at 4:03 PM, Ahmed Honest wrote:
> Dear Deba,
>
> That's INput message defined using Data Validation. For your information
> click in the cell where the message is coming up go to Data tab and
> selec
Find Attached Sheet
On Fri, Jun 15, 2012 at 10:55 AM, wrote:
> Dear all experts
>
> ** **
>
> I’ve some questions to ask in my sheet
>
> The sheet put for the forecast date and quantity each per forecast date**
> **
>
> I need to get the lastest forecast date and the quantity of that,*
Hi Smita
Just Select the Cells then Press Ctrl+G then click on Special button
then click on Radio button of Blanks and use Alt+E and press d then select
the choice what to delete Row or columns.
Thanks
Gawli Anil
On Fri, Jun 15, 2012 at 11:39 AM, NOORAIN ANSARI
wrote:
> Please attached sheet.
just put a comment on workbook.add because it takes to another workbook and
keeps on adding it whenever u click on exportto excel.
Regadrs,
Gawli Anil
On Mon, Jun 11, 2012 at 3:03 PM, NOORAIN ANSARI wrote:
> Hi,
>
> Please find attached Sheet,
> Hope it will help to you.
>
>
> --
> Thanks & re
Hello to Everyone.
My name is Anil Gawli.
I'm 25 yrs old.
Lives in Mumbai(Ambarnath).
Currently completing MCA VIth Sem frm Bangalore University.
Working in MNC company(Clariant ).
I'm working in Lean Sigma Projects.
Thanking You,
Gawli Anil
On Mon, Jun 11, 2012 at 11:24 AM, LAKSH
Dear Deba
Goto Options, Advanced and there u'll find Show Sheet Tabs checkbox option
Regards
Gawli Anil
On Fri, Jun 8, 2012 at 4:25 PM, Deba Ranjan wrote:
> Its a awesome design. Can you please tell me , in the sheet, we are
> unable to view the sheets, i mean, Even we insert sheet, we ar
just share your data.
Gawli Anil
On Tue, Jun 5, 2012 at 10:00 AM, Nagendra Modupalli wrote:
> Hi Experts,
>
> I have data with Employee number,based on employee number i need to
> get the date of join.i have many file with DOJ.
>
> What is the VBA vlookup code for looking one file and if not find
See the attached data
Regards,
Gawli Anil
On Mon, Jun 4, 2012 at 2:38 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
> Hi Maries,
>
> Thankyou for your early response.
>
> I want to show only the list of people who are available.
>
> I mean when I will select "team 1" then the gra
congrats Mr Rajan.
Gawli Anil
On Mon, Jun 4, 2012 at 9:23 AM, NOORAIN ANSARI wrote:
> Congratulation Rajan..
>
> On Sun, Jun 3, 2012 at 11:12 PM, Ayush Jain wrote:
>
>> Hello Everyone,
>>
>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
>> May'2012
>> He has
pls give me the output of the report, means it will give me idea to create.
Regards,
Gawli Anil
On Fri, Jun 1, 2012 at 1:01 PM, Tarun Mondal wrote:
> Sir , please try to solve my problem...i want to calulate income tax of
> around 300 employees and want to create quarterly return report , annua
Pls share a data with us.
Regards,
Gawli Anil
On Thu, May 31, 2012 at 1:30 PM, Divaker Pandey wrote:
> Hi Ranjan,
>
> I used an command button (activeX control) on sheet. when i open file and
> click on the button it is normal, but if i changed screen resolution, and
> start click on button agai
share your data with us .
Regards,
Gawli Anil
On Wed, May 30, 2012 at 6:09 PM, Rahul Arora wrote:
> U can use index match formula..
>
>
>
> =INDEX(Sheet1!$B$3:$G$20,MATCH(Sheet2!E3,Sheet1!$E$3:$E$20,0),MATCH(Sheet2!$G$2,Sheet1!$B$2:$G$2,0))
>
>
>
> Regards,
> Rahul
>
>
>
>
>
> On Wednesday, May
It is showing without manual extaction.
What do u want specify in brief
Regards,
Gawli Anil
On Wed, May 30, 2012 at 5:36 AM, pawel lupinski wrote:
> Dear All,
>
> I have a problem with adjusting graph, if you can look inside the file and
> advice I'll be appreciated.
>
> Regards,
>
> Pawel
On Tue, May 29, 2012 at 12:55 PM, Ahmed Honest wrote:
> Dear Amit,
>
> Use the Drop Down list options which is available in the Data Validation.
> I hope you know it. If not just google how to create drop down list you
> shall get the desired that you are looking for.
>
> Or revert to the group t
bo box in Excel?
>
>
> On Fri, May 25, 2012 at 1:27 PM, Smitha S R wrote:
>
>> Is this possible in dropdown list as you have prepared using combo box?
>>
>>
>> On Tue, May 22, 2012 at 10:05 AM, Anil Gawli wrote:
>>
>>> your attached file is c
see the attached sheet
Regards
Gawli Anil
On Tue, May 29, 2012 at 11:18 AM, Amit Gandhi wrote:
> Hi Experts
>
> I want to pick value in Cell C7, C8, C9 ………from List given in Column
> "L" in attached file.
>
> How it will be possible? Pls help me here.
>
> Regards
>
> Amit
>
>
> --
> FORUM RU
On Mon, May 28, 2012 at 4:30 PM, LAKSHMAN PRASAD wrote:
> How to collect only numeric value from a particular cell
> **
>1462NIRM
> 1462
> 1464NIRM
> 1464
> 1465NIRM
> 1465
> 1404--BL
> 1404
> 1031Infr
> 1031
> 8020LOKN
> 8020
>
u can use vlookup ...
Regards,
Anil Gawli
On Mon, May 28, 2012 at 3:42 AM, pawel lupinski wrote:
> Dear All,
> I have problem with indirect function in this case is working fine (see
> attachment), but if you can show me some extra features I'll be appreciated.
>
Just see the attached sheet FY Ref
Regards
Anil Gawli
On Thu, May 24, 2012 at 3:06 PM, Anirban Roy wrote:
> Dear Group,
>
> A24 will be prepared based on A23. Who will get highest score in every
> sheet of A24, will win and his name will be declared by the authority. Data
> e
what query u have , from the attachment i didn't understand .
On Thu, May 24, 2012 at 4:18 PM, anil kumar wrote:
> Hello friends,
>
> I have a queary plz find attahcment.
>
>
> Thanks & Regards
> Anil
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accura
give me the sample data for amending it
Regards,
Anil Gawli.
On Wed, May 23, 2012 at 10:24 PM, Aamir Shahzad wrote:
> Don - if you select the entire column, Excel will consider till the last
> used cell. Therefore no worried about the selection.
>
> Regards,
>
> Aamir Shahzad
Pls Find Attached file
On Tue, May 22, 2012 at 11:41 AM, Amit Gandhi wrote:
> Hi Experts
>
>
> I am finding some problem in excel formula, pls help me here. I have a
> excel data at two locations, 1st is Supplier's Bill details and 2nd is
> Purchase order details. I need a formula that can dist
file attached with modifications
disadvantages is that it will ask to attach for every row as an attachments.
Regards,
Anil Gawli
On Mon, May 21, 2012 at 5:44 PM, Anil Gawli wrote:
> File attached for ur Reference.
>
>
> On Mon, May 21, 2012 at 5:25 PM, renuka chari wrote:
just email a blank with out subject to
excel-macros+unsubscr...@googlegroups.com to remove yourself from the group.
Regards
Gawli Anil
On Tue, May 22, 2012 at 4:01 AM, Asa Rossoff wrote:
> Best not to quote my old post that indicates that a "remove me" subject
> will work. Google Help say
your attached file is corrupted and cannot be opned?
Regards
Gawli Anil
On Tue, May 22, 2012 at 12:20 AM, Bé Trần Văn wrote:
>
>
> 2012/5/21 Anil Gawli
>
>> with data validation i don't think so, i have prepared in combo box
>> control.
>> Is it Ok?
>&
File attached for ur Reference.
On Mon, May 21, 2012 at 5:25 PM, renuka chari wrote:
> Hi All
>
> Actually i need Export ladger data from tally in ".htm" format exported
> data saved in one perticular folder, then i need to send each individual
> file willbe sending to the individual receipitent
(s it possible to get the items in the first line in the drop down while
> start entering the letters of the items.
> Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start
> entering P itself Pen and pencils should come in the first line.)
>
>
> On Mon, May 21,
File attached FYI
On Mon, May 21, 2012 at 1:50 PM, Smitha S R wrote:
> Hi,
>
> I have a drop down list which is created using menu 'data validation'.
>
> Is it possible to get the items in the first line in the drop down while
> start entering the letters of the items.
> Eg: Item Pen, pencils,
subsidary sheet in A17 is 10020-16A-BLKC-MR. ANUPAM SARKAR and in sheet2
in A17 is 10020--BLKC-MR. ANUPAM SARKAR(2)
both are not matching that,s why
Regards,
Anil Gawli
On Fri, May 18, 2012 at 6:05 PM, LAKSHMAN PRASAD wrote:
> Hi Anil,
>
> Plz see cell D13 and D17 value or #N
Hi Reshma
for that i want your raw data .
Provide me then i can give you with the solved attached sheet
On Wed, May 16, 2012 at 11:08 AM, Reshma Shelar wrote:
> Hi,
> I want to sort my data date & name wise can i use micros for that, if yes
> please help me with the formula.
>
>
> Thanks
> Reshm
On Wed, May 16, 2012 at 9:53 AM, Deba Ranjan wrote:
> *Dear Experts, Waiting for the revert with solution. Thanks
> *
>
>
>
> Thanks & Regards,
> Deba Ranjan P
>
>
>
>
> -- Forwarded message --
> From: Deba Ranjan
> Date: Tue, May 15, 2012 at 10:22 AM
> Subject: $$Excel-Mac
PLs see attached file
On Mon, May 14, 2012 at 7:49 AM, Mr excel wrote:
> I want to know the differences between the two sheets.i.e. Main
> worksheet(Master SHEET) and the Current Month(Apr'12) Worksheet.
>
> Please give me any formula or code for finding out the differences between
> the two sh
Hey dude.
Just select all the cells .
go to Conditional formatting -> manage rules->select new rule
click on format only cells that contain "blanks " and click on format
and select the white color. that's it.
On 2/18/12, PRAVESH KUMAR wrote:
> HI,
>
>
> Please help...for conditio
On Fri, Aug 27, 2010 at 1:43 AM, Mangesh Joshi wrote:
> Dear All,
>
> In Attached sheet Product column starting word *Manufacturer of *are same
> in every Product colum. give me solution for that without copying how to add
> this word every time.
>
>
> Regards
> Mangesh
>
> --
>
> ---
99 matches
Mail list logo
