Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

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

Re: $$Excel-Macros$$ VBA developer job in Gurgaon

yes On Tue, Mar 15, 2016 at 3:53 PM, Pramod Singh <pramod...@gmail.com> wrote: > Bro have u knowledge of Excel automation? > > Pramod > On 15 Mar 2016 14:24, "Anil Gawli" <gawlianil8...@gmail.com> wrote: > >> >> >> On Tue, Mar 15, 2016

Re: $$Excel-Macros$$ VBA developer job in Gurgaon

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 >

Re: $$Excel-Macros$$ VLOOKUP NOT WORKING

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

Re: $$Excel-Macros$$ Why does my sheet tab 'calculate' if there are no formulas on the tab?

Dear , Pl share the workbook with us On Fri, Jul 31, 2015 at 2:02 AM, Rob Flott robfl...@gmail.com 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

Re: $$Excel-Macros$$ Re: Want to work on single workbook with multiple user at a time.

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 nasirsa...@gmail.com 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

Re: $$Excel-Macros$$ Excel Job

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 n...@perceptive-analytics.com wrote: We are looking to hire folks who love Microsoft Excel for Team Lead and Business Analyst roles. We don't mind the

Re: $$Excel-Macros$$ To Select a Pivot Item

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 idforex...@gmail.com wrote: Can anybody help me with a solution. Regards, Faisal PK On Fri, Mar 13, 2015 at 11:04 AM, Faisal Pk

Re: $$Excel-Macros$$ Excel VBA to hide sheets of a workbook closes others too

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 gauravdev1...@gmail.com wrote: Hi, I tried working on

Re: $$Excel-Macros$$ multi mailer

Dear Gaurav, Pls share the file regards, Anil On Tue, Feb 3, 2015 at 10:25 AM, Gaurav Devrani gauravdev1...@gmail.com 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

Re: $$Excel-Macros$$ Re: Help required for Match DATA

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 direct2as...@gmail.com wrote: Dear

Re: $$Excel-Macros$$ Urgent need of MySQL DBA ==== Atlanta, GA.

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 kmazhar...@gmail.com 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.

Re: $$Excel-Macros$$ Happy New 2015

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 eugene.bern...@gmail.com wrote: Hi all, Happy new year to you all. Regards Eugene On Wed, Dec 31, 2014 at 7:54 PM, Vaibhav Joshi v...@vabs.in wrote: Joyous

Re: $$Excel-Macros$$ Complex formula Solution

Dear Amar, PFA. Regards, Gawli Anil. On Fri, Dec 26, 2014 at 10:30 AM, amar takale amartak...@gmail.com 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 v...@vabs.in wrote: Hi from where you are arriving

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

Dear Rockernayal, Pls share a workbook with us. Regards, Gawli Anil On Mon, Dec 22, 2014 at 3:15 PM, Mandeep Baluja rockerna...@gmail.com 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

Re: $$Excel-Macros$$

Pl share the workbook with us On Thu, Nov 27, 2014 at 2:56 PM, Shrinivas Shevde shrinivas...@gmail.com 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

Re: $$Excel-Macros$$ Re: Amendment (With exception) on the the created vendor macro file

Dear Laxmanan, attachment is not there On Tue, Nov 25, 2014 at 12:32 PM, Laxmanan M laxflyflow...@gmail.com 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

Re: $$Excel-Macros$$ Re: Macro for send mail

Dear Mr. Ladmanan, Pls do send an attachment. Warm Regards, Gawli Anil On Thu, Nov 20, 2014 at 11:53 PM, Laxmanan M laxflyflow...@gmail.com 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

Re: $$Excel-Macros$$ Port VBA code to VB.net

Dear Rupesh, Pls share the file. Warm Regards, Gawli Anil. On Thu, Oct 9, 2014 at 1:50 PM, Rupesh Patil patil.rupesh1...@gmail.com 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

Re: $$Excel-Macros$$ Move Selected Names to Listbox

Dear Hilary, Pl find attached as required by you Warm Regards, Gawli Anil :) On Wed, Oct 1, 2014 at 3:10 PM, Hilary Lomotey resp...@gmail.com 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

Re: $$Excel-Macros$$ Sum Product with Time

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 chandrashekarb@gmail.com wrote: Hello Vaibhv, It seems formula is wrong count should be 4 but its giving as 7. Could you please check it. Thanks

Re: $$Excel-Macros$$ save active sheet in new workbook

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 patil.rupesh1...@gmail.com wrote: Hello Expert, I need your help. I need VBA

Re: $$Excel-Macros$$ Mass mailer help!!!

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 jonnie...@gmail.com wrote: Hi All, I need an urgent help. I have to send a mass mailer to approx 10k email addresses. The task at hand

Re: $$Excel-Macros$$ load graph in userform

​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 resp...@gmail.com 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

Re: $$Excel-Macros$$ Re: Create macro to save macro template as macro enabled workbook using cell value as file name

​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 rjagai...@gmail.com wrote: Well Paul there's a guy in England who

Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code

as ever you can.” - John Wesley - From: Anil Gawli gawlianil8...@gmail.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com; anky...@gmail.com Sent: Friday, June 20, 2014 1:11 AM Subject: Re: $$Excel-Macros$$ Excel VBA Password Issues

Re: $$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code

Dear Ankur, Pl share the workbook with us. Warm Regards, Gawli Anil. On Fri, Jun 20, 2014 at 10:36 AM, Ankur Gupta anky...@gmail.com 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

Re: $$Excel-Macros$$ Creating macro for formatting all cells to accounting format

Dear Daniel, Pl share a workbook with us. Warm Regards, Gawli Anil On Fri, May 30, 2014 at 1:32 PM, Kof Bar danielki...@gmail.com wrote: Hi, I would like to create a macro that will format all cells in a worksheet to accounting format: _(* #,##0.00_);_(* (#,##0.00);_(* -??_);_(@_)

Re: $$Excel-Macros$$ Averege by Using by Sumproduct.

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 prafulltjad...@gmail.com wrote: Dear All, Good Evening , 1)I am not able to calculate the Average

Re: $$Excel-Macros$$ Problem with Advanced Filter

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 mr.exce...@gmail.com wrote: Plz share your workbook Thanks regards, www.MrExcel4U.com On Thu, Feb 27, 2014 at

Re: [XL-VBA Clinic] RE: $$Excel-Macros$$ Macro Required

Dear Praful, Pl find the modified file as req. Warm Regards, Gawli Anil On Wed, Feb 26, 2014 at 5:18 PM, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear Ravinder Sir, Thanks for Reply..it is working fine. Can we make the same without selecting Range and paste range(Without message

Re: $$Excel-Macros$$ fill a column with a formula to a specific index.

Dear Maria, Pl share the workbook with us. Warm Regards, Gawli Anil. On Tue, Feb 25, 2014 at 2:54 PM, MH s.mariamha...@gmail.com 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

Re: $$Excel-Macros$$ excel query

Dear Shankar, Pl find attached. Warm Regards, Gawli Anil. On Mon, Feb 10, 2014 at 2:27 PM, Shankar Bheema shankar.n...@gmail.com 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

Re: $$Excel-Macros$$ Conditional formatting

Dear Fonbery, Pl share the workbook with us. Warm Regards, Gawli Anil/. On Thu, Jan 23, 2014 at 7:45 PM, Berinyuy Fonyuy fonb...@gmail.com 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

Re: $$Excel-Macros$$ Run time error '1004' Method Range of oblect '_Globle fails

Dear Rupesh, Kindly share the workbook with us. Warm Regards, Gawli Anil On Thu, Jan 2, 2014 at 1:37 PM, Rupesh Patil patil.rupesh1...@gmail.comwrote: Hi expert Please look below code and tell me why I am getting this error(Mentions in subject line) Private Sub ComboBox1_Click()

Re: $$Excel-Macros$$ About Formula

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 patil.rupesh1...@gmail.com wrote: Hi Experts, =VLOOKUP(K2,A2:K494,6,FALSE) Can any one suggest me, what is wrong

Re: $$Excel-Macros$$ Counting visible cells in Pivot table

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 chandrashekarb@gmail.com wrote: Hello, How to get count of visible cells in

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data-

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 rajansharma9...@gmail.com wrote: Dear all experts, Is my query is valid ?

Re: $$Excel-Macros$$ Need Help Excel gurus

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 py.har...@gmail.com wrote: Hi Vinay, In the location wise work sheet when i

Re: $$Excel-Macros$$ Macro for Vlookup

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 ganeshg...@gmail.com wrote: Hi Team, I am learning macros. I have run macro to lookup 2 Employee ID list. But that

Re: $$Excel-Macros$$ Re: Display Vlookup dialog box with vba code

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 douglas.r...@timken.com wrote: Would anyone know how to change or control where the vlookup window opens in code? On Tuesday, October

Re: $$Excel-Macros$$ help required on attached Macro

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 jocky6...@gmail.com wrote: Hi Team, Can anybody fix this attached error for me. i

Re: $$Excel-Macros$$ Required Prefix Macro for the numbers

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 Outlet =

Re: $$Excel-Macros$$ Paste Special With transpose and links to the source data

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

Re: $$Excel-Macros$$ Error--Cant Exit Design Mode

Pl share u r excel sheet to make us clear... Regards, Gawli Anil On Tue, Jul 17, 2012 at 11:39 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Hanumant, Please share your workbook with group. -- Thanks regards, Noorain Ansari www.noorainansari.com

Re: $$Excel-Macros$$ Help:- Required VBA Code for Restrict Previous Week Data Entry......

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 noorain.ans...@gmail.comwrote: Dear DS, Please try it.. *Private Sub CommandButton1_Click() Dim i As Integer Dim dt As Date i = Cells(Rows.Count,

Re: $$Excel-Macros$$ Help:- Required VBA Code for Restrict Previous Week Data Entry......

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, Anil Gawli gawlianil8...@gmail.comwrote: dear noorian How u add the Dt picker in user

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

Pls find Attached sheet ...Like this u want? Regards, Gawli Anil On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, I need your help to solve my PT Problem. The description is given in sheet itself. Please FA. Thanks. -- With regards, MaNgEsH

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

of Anil's Formula in green part =GETPIVOTDATA(Average of Salary [INR],$E$1,Dept,*$E3*)/55 Calculated Field solution is also attached here with screen shot. On Mon, Jul 16, 2012 at 5:15 PM, Anil Gawli gawlianil8...@gmail.com wrote: Pls find Attached sheet ...Like this u want? Regards

Re: $$Excel-Macros$$ R1C1

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

Re: $$Excel-Macros$$ Extract All Data when drop down list is selected

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

Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June​'12)

heartly congrats Mr Rajan..:) Regards, Gawli Anil. On Thu, Jul 5, 2012 at 8:32 AM, Raghav raghav.bhupen...@gmail.com wrote: Congratulations Rajan. ** ** Regards, Raghav Sr. Analyst Tata Teleservices Ltd. ** ** *From:* excel-macros@googlegroups.com

Re: $$Excel-Macros$$ need a macro to change the background color a cell as soon as i change the value (alphanumeric)

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

Re: $$Excel-Macros$$ Remove Punctuation

pls find attached sheet On Wed, Jun 27, 2012 at 2:52 PM, Deba Ranjan drdeva...@gmail.com 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

Re: $$Excel-Macros$$ Need a VBA code

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 in that

Re: $$Excel-Macros$$ Remove Punctuation

for removing 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 gawlianil8...@gmail.comwrote: sorry for wrong attachment just see this attachment On Wed, Jun 27, 2012 at 3:30 PM

Re: $$Excel-Macros$$ Re: delete blank columns

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 prince141...@gmail.comwrote: Hi Smitha, Please use this Macro hope this help you. Public Sub DeleteBlankCols(strSheetName As

Re: $$Excel-Macros$$ Excel Q A

Hi Krishna, Thanks 4 sharing ... Regards, Gawli Anil On Wed, Jun 20, 2012 at 8:35 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Nice collection, Kirshna Thanks to sharing with group. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com

Re: $$Excel-Macros$$ delete blank columns

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 noorain.ans...@gmail.comwrote:

Re: $$Excel-Macros$$ Seems Like comments but Not

Yes that is created by data validation Ahmed is Right. Regards, Gawli Anil On Fri, Jun 15, 2012 at 4:03 PM, Ahmed Honest ahmedhon...@gmail.com 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

Re: $$Excel-Macros$$ What is Application.OnKey, Application.OnTime

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 excelvba.lear...@gmail.com wrote: Hi Group, Pls explain, What is Application.OnKey,

Re: $$Excel-Macros$$ Introduce Yourself !!

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, LAKSHMAN PRASAD

Re: $$Excel-Macros$$ export Userform Listbox data to new excel worksheet

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 noorain.ans...@gmail.comwrote: Hi, Please find attached Sheet, Hope it will help to you.

Re: $$Excel-Macros$$ Clock Chart (Excellent)

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 drdeva...@gmail.com wrote: Its a awesome design. Can you please tell me , in the sheet, we are unable to view the sheets, i mean, Even we

Re: $$Excel-Macros$$ Graph with radio button

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 graph should

Re: $$Excel-Macros$$ Urgent help required for Vlookup macro code

just share your data. Gawli Anil On Tue, Jun 5, 2012 at 10:00 AM, Nagendra Modupalli naga14...@gmail.comwrote: 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

Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)

congrats Mr Rajan. Gawli Anil On Mon, Jun 4, 2012 at 9:23 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Congratulation Rajan.. On Sun, Jun 3, 2012 at 11:12 PM, Ayush Jain jainayus...@gmail.comwrote: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member'

Re: $$Excel-Macros$$ INCOME TAX HELP

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 tarunmondal1...@gmail.comwrote: Sir , please try to solve my problem...i want to calulate income tax of around 300 employees and want to create

Re: $$Excel-Macros$$ ActiveX Control on an Excel 2010 worksheet change size after you change the screen resolution

Pls share a data with us. Regards, Gawli Anil On Thu, May 31, 2012 at 1:30 PM, Divaker Pandey divake...@gmail.com 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

Re: $$Excel-Macros$$ Re: VLLOKUP IS NOT WORKING

share your data with us . Regards, Gawli Anil On Wed, May 30, 2012 at 6:09 PM, Rahul Arora rahul.man...@gmail.com 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

Re: $$Excel-Macros$$ How to pick values from particular table/list

see the attached sheet Regards Gawli Anil On Tue, May 29, 2012 at 11:18 AM, Amit Gandhi silkyro...@gmail.com 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 --

Re: $$Excel-Macros$$ Drop down list

the combo box in Excel? On Fri, May 25, 2012 at 1:27 PM, Smitha S R sperdwo...@gmail.com 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 gawlianil8...@gmail.comwrote: your attached file is corrupted and cannot

Re: $$Excel-Macros$$ How to pick values from particular table/list

On Tue, May 29, 2012 at 12:55 PM, Ahmed Honest ahmedhon...@gmail.comwrote: 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

Re: $$Excel-Macros$$ adjusting graph

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 lupins...@yahoo.com wrote: Dear All, I have a problem with adjusting graph, if you can look inside the file and advice I'll be appreciated.

Re: $$Excel-Macros$$ problem with indirect function

u can use vlookup ... Regards, Anil Gawli On Mon, May 28, 2012 at 3:42 AM, pawel lupinski lupins...@yahoo.com 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. Regards, Pawel

Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell

On Mon, May 28, 2012 at 4:30 PM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: How to collect only numeric value from a particular cell ** 1462NIRM 1462 1464NIRM 1464 1465NIRM 1465 1404--BL 1404 1031Infr 1031 8020LOKN

Re: $$Excel-Macros$$ queary

what query u have , from the attachment i didn't understand . On Thu, May 24, 2012 at 4:18 PM, anil kumar kmr7a...@gmail.com wrote: Hello friends, I have a queary plz find attahcment. Thanks Regards Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,

Re: $$Excel-Macros$$ A24 workbook will be prepared based on A23

Just see the attached sheet FY Ref Regards Anil Gawli On Thu, May 24, 2012 at 3:06 PM, Anirban Roy excelanir...@gmail.com 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

Re: $$Excel-Macros$$ Vlookup is not working

give me the sample data for amending it Regards, Anil Gawli. On Wed, May 23, 2012 at 10:24 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: Don - if you select the entire column, Excel will consider till the last used cell. Therefore no worried about the selection. Regards, Aamir Shahzad

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

Pls Find Attached file On Tue, May 22, 2012 at 11:41 AM, Amit Gandhi silkyro...@gmail.com 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

Re: $$Excel-Macros$$ Drop down list

File attached FYI On Mon, May 21, 2012 at 1:50 PM, Smitha S R sperdwo...@gmail.com 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

Re: $$Excel-Macros$$ Drop down list

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, 2012 at 2:28 PM, Anil Gawli gawlianil8

Re: $$Excel-Macros$$ Drop down list

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 betnmtdongna...@gmail.comwrote: 2012/5/21 Anil Gawli gawlianil8...@gmail.com with data validation i don't think so, i have prepared in combo box control. Is it Ok

Re: $$Excel-Macros$$ REMOVE ME

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 a...@lovetour.info wrote: Best not to quote my old post that indicates that a remove me subject will work.

Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm

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 gawlianil8...@gmail.com wrote: File attached for ur Reference. On Mon, May 21, 2012 at 5:25 PM, renuka chari jva.ch

Re: $$Excel-Macros$$ unable to use advance vlookup

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 lakshman_...@yahoo.comwrote: Hi Anil, Plz see cell D13 and D17

Re: $$Excel-Macros$$ Form tracker and new base

On Wed, May 16, 2012 at 9:53 AM, Deba Ranjan drdeva...@gmail.com wrote: *Dear Experts, Waiting for the revert with solution. Thanks * Thanks Regards, Deba Ranjan P -- Forwarded message -- From: Deba Ranjan drdeva...@gmail.com Date: Tue, May 15, 2012 at 10:22

Re: $$Excel-Macros$$ Want to use micros

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 onlyx...@gmail.com 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.

Re: $$Excel-Macros$$ Find differences in two worksheets.

PLs see attached file On Mon, May 14, 2012 at 7:49 AM, Mr excel excelkeec...@gmail.com 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

$$Excel-Macros$$ Conditional formatting

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 praveshkash...@gmail.com wrote: HI, Please

Re: $$Excel-Macros$$ Give a Solution

On Fri, Aug 27, 2010 at 1:43 AM, Mangesh Joshi mangeshdjo...@gmail.comwrote: 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 --