Re: $$Excel-Macros$$ How to count

dear Jayendra Pls find Attached Excel sheet for your ref Regards, Anil Gawli On Wed, Jul 25, 2012 at 10:10 AM, jayendra gaurav <> wrote: > > > > Team, > > How to count a cell based on color . > > file is attached for your's reference. > > > > > -- > J.Gaurav > Call-7838594954 > > -- > -- > FO

Re: $$Excel-Macros$$ Re: Summary Sheet for all Employees

dear prkhan, Share ur data with groups... Regards, Gawli Anil On Wed, Jul 25, 2012 at 12:50 PM, prkhan56 <> wrote: > Hello, > With the present data, I cannot. > That is what I will do when I get all the Emp details in a summary sheet. > Now the Emp names are in columns. > I wish to have their d

Re: $$Excel-Macros$$ Fwd: Office 2013 + YOY Reporting + 5 Useful Shortcuts + Cluttered Data

Dear Noorian, Thanks for the precious information.. Regards, Gawli Anil On Wed, Jul 25, 2012 at 5:36 PM, NOORAIN ANSARI <> wrote: > FYI > > -- Forwarded message -- > From: ExcelUser > Date: Wed, Jul 25, 2012 at 5:30 PM > Subject: Office 2013 + YOY Reporting + 5 Useful Shortc

Re: $$Excel-Macros$$ Excel VBA to loop through rows and delete blank lines

Dear Tony, U can use without macro Just select the range and press ctl+G of press F5 function key . Then click to blank cell and use Alt+E+D select the row and delete it Regards, Gawli anil On Thu, Jul 26, 2012 at 8:42 AM, NOORAIN ANSARI wrote: > Dear Tony, > > Please try it.. > > *Sub Dele

Re: $$Excel-Macros$$ Re: Cursor Drag Option in Excel

Drag the cursor when the cursor become "+" sign and drag. Regards, Gawli Anil On Wed, Jul 25, 2012 at 11:49 PM, kumar.ashish861 wrote: > Dear Balbir, > > First u have to select a cell & copy it (what you want to paste), then > select a range, including the copied cell (where u want to paste th

Re: $$Excel-Macros$$ Re: Cursor Drag Option in Excel

take it to the right side corner dude... Regards Gawli Anil On Thu, Jul 26, 2012 at 10:49 AM, balbirkumar . wrote: > Thanks for support . But my problem is the cursor does not become "+" sign > to drag. Please suggest. > > > On 26 July 2012 10:32, अनिल नारायण गवली wr

Re: $$Excel-Macros$$ Budgeting Process

pls share the data with us Regards Gawli Anil On Fri, Jul 27, 2012 at 11:55 AM, David Grugeon wrote: > Yes I would use Vlookups. The issue is to get the formulas to use the > different sourcebooks. Probably your best bet is to cut and paste all the > lines from the 10 source workbooks onto one

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

Dear Bhat. Pls find Attached Sheet FYI Regards, Gawli Anil On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S <> wrote: > Dear Experts, > > Good Morning. > > I have a case where in Data is built in with Text (1 & 2 Digits, Eg: 1 > Uttar Pradesh, 20 Jharkhan) and without text also (CSD, Nepal). I >

Re: $$Excel-Macros$$ Text With Numbers : Replaced with Text

Pls find attached sheet FYI Regards, Gawli Anil On Fri, Jul 27, 2012 at 12:47 PM, NOORAIN ANSARI wrote: > Dear JP, > > Please use.. > > *=SUBSTITUTE(UPPER(E7),CHAR(ROW(INDIRECT("48:58"))),"")* > > > On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash S <> wrote: > >> Dear Experts, >> >> Good Morning. >

Re: $$Excel-Macros$$ Re: Download MS Office 2013 (Trial version)

Is it can run on winxp sp3 or not? Regards, Gawli Anil On Tue, Jul 31, 2012 at 4:15 PM, NOORAIN ANSARI wrote: > Dear Joshep, > > Please see screen shot... > > On Tue, Jul 31, 2012 at 10:16 AM, joseph camill > wrote: > >> Hi Noorain, >> >> Please help me understand, I may be wrong. I do not

Re: $$Excel-Macros$$ help required

pl share us with some files.. Regards, Gawli Anil. On Wed, Aug 1, 2012 at 2:36 PM, ARUN(°•¤a®µn¤•°™) <> wrote: > Dear Members, > Need a macro for converting one subtotal part into diffrent sheets from a > workbook. > 10x & regards > Arun > > > > -- > FORUM RULES (986+ members already BANNED for v

Re: $$Excel-Macros$$ just a wild thought regarding table in one cell

pl share a data with groups. Regards, Gawli Anil On Fri, Aug 3, 2012 at 11:52 AM, सुनिता पौडेल wrote: > Dear all, > > Is there any possibility to create a small table where data can be put to > clarify the reason of the amount of one certain cell instead of inserting a > comment box? I mean if w

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

congrats noorian ansari:) Regards, Gawli Anil On Sat, Aug 4, 2012 at 10:38 AM, Kuldeep Singh wrote: > > Congratulations Noorain Sir. > > Regards, > Kuldeep Singh > Back Office Executive (MIS) > Info Edge India Limited (naukri.com) > Phone.: +91-120-4763789, Extn.: 789,9716615535 > naukrik

Re: $$Excel-Macros$$ Run-time error popup message

I didn't understand your remaining 50% query. Exactly what u want and how? Pl elaborate it... Regards, Gawli Anil On Mon, Aug 6, 2012 at 2:25 PM, Lokesh Loki <> wrote: > Hi All, > > It's urgent anybody please resolve my query. I hope all of you understand > my concern. > > Regards > Lokesh.M > >

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

Dear Amar Your formula is right if you want only the highlighted color then on filter field click on filter by color . it is easily available there Thanks & Regards, Gawli anil On Tue, Aug 21, 2012 at 3:20 PM, amar takale wrote: > Hi Amresh > I used excel 2003 So I cant see formulas.I also

Re: $$Excel-Macros$$ Required VBA code for Unprotect All sheet at one time

Dear Amar, Pls find attached sheet enclosed. Regards, Gawli Anil On Wed, Aug 22, 2012 at 11:49 AM, amar takale wrote: > Hi all Experts, > How to all worksheets protect to unprotect at one time,Is there any VBA > code to unprotect sheet at one time. > > -- > Join official facebook page of this

Re: $$Excel-Macros$$ Required VBA code for Unprotect All sheet at one time

It's ok Amar. Its our duty to help our Groups... Regards, Gawli Anil On Wed, Aug 22, 2012 at 12:21 PM, amar takale wrote: > Dear Anil > Thanks very much for this help.I was searching this code long times.Really > I will thanks to you. > Amar > > > On Wed, Aug 22, 201

Re: $$Excel-Macros$$ Hook Chart

Gr8 work rajan .:) Regards, Gawli Anil On Wed, Aug 22, 2012 at 9:34 PM, Hilary Lomotey wrote: > i love the chart, nice work bro > > > On Wed, Aug 22, 2012 at 3:35 PM, Kuldeep Singh wrote: > >> >> Hi Sir, >> >> It's really good. >> >> Regards, >> Kuldeep Singh >> >> >> On Wed, Aug 22, 2012 a

Re: $$Excel-Macros$$ Please Add my ID to this group

To post to this group, send email to excel-macros@googlegroups.com. Regards, Gawli Anil On Wed, Aug 22, 2012 at 8:10 PM, Anil Jangra wrote: > Hi, > > I want to joing this group and would like to recieve emails from this > group. > > I am working with AonHewitt as Data Analyst. I am an beginner i

Re: $$Excel-Macros$$ Data validation solution

Deat Amar U have to select all the required cells at one time and then foto formula bar and then press Cltr+Enter. Hope it should work . reply me when done. Regards, Gawli Anil On Fri, Aug 24, 2012 at 11:12 AM, amar takale <> wrote: > Hi All > I found Data validation sheet in group,It is ok if c

Re: $$Excel-Macros$$ Fwd: Required Challenging formula

Dear Amar, The file u had given to us is corrupted. kindly send again. Regards, Gawli Anil On Fri, Aug 24, 2012 at 10:51 AM, amar takale <> wrote: > Can anybody solve my problem > Pls suggest me foe formula > > -- Forwarded message -- > From: amar takale > Date: Wed, Aug 22,

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Dear Pravesh, Enclosed herewith your query solu Regards, Gawli Anil On Thu, Aug 30, 2012 at 10:26 AM, Kuldeep Singh wrote: > > Dear Preavesh, > > 04 solutions of you. for any query please see attachment. > > =LOOKUP(H3,$C$3:$D$9) > =VLOOKUP(H3:H6,$C$3:$D$9,2,0) > =VLOOKUP(H3,$C$3:$D$9,2,0) > =IF

Re: $$Excel-Macros$$ Need help

Dear Sriram Attached is the Eg of Vlookup furmulae Thanks & Regards, Gawli Anil On Fri, Aug 31, 2012 at 12:26 PM, pankaj sangotra wrote: > Hi Sriram, > > Vlookup is used to pick values from tables for lookup values... > > For more details use techonthenet.com.. This is an awesome website.. If

Re: $$Excel-Macros$$ Need help

It would be grt to our group.. KIU. Thanks & Regards, Gawli Anil On Fri, Aug 31, 2012 at 1:24 PM, vijayajith VA wrote: > Hi Noorain, > > Isna(vlookup) > > > On Fri, Aug 31, 2012 at 1:16 PM, NOORAIN ANSARI > wrote: > >> Dear Group, >> >> If any have more example except it please share, we have

Re: $$Excel-Macros$$

try =NETWORKDAYS formula Thanks & Regards, Gawli Anil On Fri, Aug 31, 2012 at 1:39 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello, > I need a formula for dates which excludes Saturday, Sunday & Holidays(in > sheet2). Could you please help with the formulas. > > Thanks in advan

Re: $$Excel-Macros$$

try =NETWORKDAYS formula Thanks & Regards, Gawli Anil On Fri, Aug 31, 2012 at 1:41 PM, अनिल नारायण गवली wrote: > try =NETWORKDAYS formula > > Thanks & Regards, > Gawli Anil > > On Fri, Aug 31, 2012 at 1:39 PM, Chandra Shekar < > chandrashekarb@gmail.com

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

Dear noorian, Congrats Dear..:) Thanks & Regards, Gawli Anil On Mon, Sep 3, 2012 at 10:20 AM, Kuldeep Singh wrote: > > Congrats Noorain Sir. > > Regards, > Kuldeep Singh > Back Office Executive (MIS) > Info Edge India Limited (naukri.com) > Phone.: +91-120-4763789, Extn.: 789 >

Re: $$Excel-Macros$$ size of mail

the max size for attachind a file is 25 mb. your are getting a error message but what message is showing over there how we know. mention error description . On Mon, Sep 3, 2012 at 3:28 PM, L.K. Modi wrote: > Dear all > > as i m uploading file containing size of 25 mb at gmail to send but its

Re: $$Excel-Macros$$ size of mail

go to this site and see http://support.google.com/mail/bin/answer.py?hl=en&answer=8770 U must be using .exe file for attaching . just confirm. On Mon, Sep 3, 2012 at 3:33 PM, Kuldeep Singh wrote: > > > Hi, > > Gmail is not supported file size 25 MB. This facility only yahoo mail > only. Option i

Re: $$Excel-Macros$$ size of mail

how can we understand what file u r attaching dude... just elaborate and explain... On Mon, Sep 3, 2012 at 3:40 PM, L.K. Modi wrote: > sir > > thats a long song dedicated to someone. is this possible with yahoo mail. > > > On Mon, Sep 3, 2012 at 3:33 PM, Kuldeep Singh wrote: > >> >> Hi, >> >> G

Re: $$Excel-Macros$$ Question chart

Dear Pravesh, See i have changed the dropdown working . pls do the color , as i'm busy with other work. On Fri, Sep 7, 2012 at 9:48 AM, PRAVESH KUMAR <> wrote: > HI Team, > > > please help me to solve this queston it's very urgent. > > solve asap. > > > > -- > > Thanks & Regards > > Pravesh Kuma

Re: $$Excel-Macros$$ RE: SAP FICO group

Anil Narayan Gawli Mb:-09769855615 gawli_anil8...@yahoo.co.in gawlianil8...@gmail.com On Mon, Sep 10, 2012 at 1:40 PM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > Hi All, > > ** ** > > First of all thanks to all experts who helping to the world with their > expertise knowledge

Re: $$Excel-Macros$$ Excel sheet wise restrictions required for end users

Try this attachment On Wed, Sep 12, 2012 at 2:28 PM, Pravin Gunjal wrote: > Dear Masters, > > > > In the attached file there are six working sheets in it. > > The concerned person will send a mail of this file to his down level for > their working/use. > > > > *Sheet 1 *is made for the master (

Re: $$Excel-Macros$$ RE: Sorting all the sheets together

whr is the attachment?? On Fri, Sep 14, 2012 at 10:26 AM, Amit Desai (MERU) wrote: > Please help me understand, how this works? > > ** ** > > Best Regards, > > Amit > > ** ** > > *From:* Prince Dubey [mailto:prince141...@gmail.com] > *Sent:* 13 September 2012 23:16 > *To:* excel

Re: $$Excel-Macros$$ lookup or vLookup

Dear Simon, Pl share us a sample workbook. Regards Gawli Anil On Sat, Sep 15, 2012 at 10:12 AM, ashish koul wrote: > try this > VLOOKUP(A2,B:C,2,0) > remove extra spaces from the columns > > Regards > Ashish > > > > On Sat, Sep 15, 2012 at 12:51 AM, SimonCoder wrote: > >> I have a formula I'

Re: $$Excel-Macros$$ Sum() formula considering multiple values!

pl use =SUMPRODUCT((B3:B85=H8)*(C3:C85=I8)*(D3:D85=J8)*(E3:E85)) Regards Gawli Anil On Tue, Sep 25, 2012 at 9:58 AM, Vabz wrote: > Hi > > For more understanding on sumproduct with real life examples please refer > following link: > > Link

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member September 2012 *

from deep of my heart Congrats dear.Good luck for your future... Regards, Gawli Anil On Wed, Oct 3, 2012 at 6:25 PM, Rajan_Verma wrote: > *Thanks to all.* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailt

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member September 2012 *

Dear Rajan, congrats...:) On Fri, Oct 5, 2012 at 5:46 PM, prkhan56 wrote: > Congrats! > > On Wednesday, October 3, 2012 3:43:49 PM UTC+4, NOORAIN ANSARI wrote: > >> I can say only... >> >> यूँ ही बरकरार रखो भाई अपने Expertise के छाप को. >> और अपनी तरक

Re: $$Excel-Macros$$ Is it possible to Open a Particular Website and Login to it using VBA???

Pls see the attachment it is in Sheet 1 and sheet 2 one is for gmail and second is for yahoo. On Mon, Oct 8, 2012 at 11:28 PM, Sam Mathai Chacko wrote: > This is a link by Lalit Mohan, one of the members of this forum > > > http://powerofexcel.wordpress.com/2012/09/12/google-login-automation-thro

Re: $$Excel-Macros$$ Is it possible to Open a Particular Website and Login to it using VBA???

attached On Wed, Oct 10, 2012 at 3:19 PM, अनिल नारायण गवली wrote: > Pls see the attachment it is in Sheet 1 and sheet 2 one is for gmail and > second is for yahoo. > > > On Mon, Oct 8, 2012 at 11:28 PM, Sam Mathai Chacko wrote: > >> This is a link by Lalit Mohan, one of t

$$Excel-Macros$$ pls subcribe me ASAP

-- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

$$Excel-Macros$$ Re: pls subcribe me ASAP

Dear Groups, Pl ssubcribe me .. Thanks & Regards, Gawli Anil On Thu, Oct 11, 2012 at 12:24 PM, अनिल नारायण गवली wrote: > > > -- > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software Services Pvt Ltd > -- Thanks & Regards, G

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member September 2012

congrats rajan Regards, Gawli Anil On Fri, Oct 12, 2012 at 11:09 PM, Rajasekhar Praharaju < rajasekhar.prahar...@gmail.com> wrote: > Congrats rajan for your threshold efforts.. > > > On Wed, Oct 3, 2012 at 2:19 AM, Asa Rossoff wrote: > >> I'm happy to see you recognized and honored for your cont

$$Excel-Macros$$ Pls help me on this.

Dear Groups and Noorian, I want a macro that import other worksheets in a excel workbook by using filedailogbox . 1) when filedailogbox opens i have to select the required file and automatically all the sheets name should displayed in a box from that i have to select one sheet and import that in

$$Excel-Macros$$ Re: Pls help me on this.

Pls somebody help me on this On Monday, October 15, 2012 5:37:44 PM UTC+5:30, अनिल नारायण गवली wrote: > > Dear Groups and Noorian, > > I want a macro that import other worksheets in a excel workbook by using > filedailogbox . > > 1) when filedailogbox opens i have to sel

Re: $$Excel-Macros$$ Pls help me on this.

Dear noorian, Pls help me awaiting for your reply On Mon, Oct 15, 2012 at 5:37 PM, अनिल नारायण गवली wrote: > Dear Groups and Noorian, > > I want a macro that import other worksheets in a excel workbook by using > filedailogbox . > > 1) when filedailogbox opens i have to select

Re: $$Excel-Macros$$ Fwd: FW: FYIP

R u using Mozilla firefox then manage Addon . Regards, Gawli anil On Thu, Oct 18, 2012 at 10:23 AM, Shrinivas Shevde wrote: > > **Dear Group Members, > > I am using Excel 2010 .I was trying to copy paste a data from one workbook > to another workbook. > > I am getting following message > > Can a

Re: $$Excel-Macros$$ Re: Pls help me on this.

ly took me longer to write this "rant" than it did to throw > together the code. > > hope this helps get you started. > > > *Paul* > > - > *“Do all the good you can, > By all the means you can, > In all the ways you ca

$$Excel-Macros$$ Pls Help Me on this

suppose there is one two excel file one is A second is B in A file there is 2 fields like (Shiptocode) and (Productcode). in B file there is 5 fields like (Shiptocode) and (Productcode)and(Type) Type field is only two value (TRUE or FALSE) and (DP) and (RSP). i have inserted and new field in A file

Re: $$Excel-Macros$$ Re: Text need in different collume

Dear Manoj, Pl find enclosed the attachment. Regards, On Tue, Oct 23, 2012 at 11:18 AM, Manoj Kumar wrote: > Dear Expert, > >> >> I have data witch has Text and Number i want to do saperate text and >> number in next collume. >> >> man25oj kuma112r ro444ha25n 25s26on7 >> >> >> >> Regard >

Re: $$Excel-Macros$$ Vlookup with total

kindly share a sample file with groups,, Regards, Gawli Anil On Tue, Oct 23, 2012 at 12:56 PM, Amit Desai (MERU) wrote: > Dear All, > > ** ** > > I have an excel file for which, there is Incentive worked out based on 2-3 > parameters for the same Technician. > > ** ** > > I want to do a

Re: $$Excel-Macros$$ Help need to get multiple values by vlookup

Pl Share a sample sheet with us On Thu, Oct 25, 2012 at 9:52 AM, David Grugeon wrote: > It seems to me that sorting might be a better approach than a vlookup. > > Regards > David Grugeon > > > On 25 October 2012 14:15, Saravanan wrote: > > Hi > > > > I need this because need to know which are a

Re: $$Excel-Macros$$ Re: Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

Dear Manoj. Pl find attached sheet. Regards, Gawli Anil On Fri, Oct 26, 2012 at 2:16 PM, Vabz wrote: > PFA > > Cheers//Vabs > > > On Friday, October 26, 2012 12:00:00 PM UTC+5:30, Manoj Kumar wrote: >> >> Dear Expert, >> >> Please help me to get the currect ans with attached file.. >> >> >> Re

Re: $$Excel-Macros$$ need help

Pl find attached sheet for you info. Excuse typo errors... Regards, Gawli Anil On Wed, Oct 31, 2012 at 11:55 AM, Neeraj wrote: > Dear Experts, > > ** ** > > Kindly find the attached sheet and resolve the problem…. > > -- > Join official facebook page of this forum @ > https://www.face

Re: $$Excel-Macros$$ Recover Excel File

Yes Dear, Just goto Run type %appdata% in that goto Microsoft-> Excel there u'll find the old data . Regards, Anil Gawli On Wed, Oct 31, 2012 at 7:39 PM, Paul Schreiner wrote: > There are many possibilities, but most depend on your computer system. > > Do you (or someone else) regularly back up

Re: $$Excel-Macros$$ Unhide sheet

Dear Amar, open excel sheet press Alt+f11 insert a module copy following code Sub UnHideAllSheets() For Each c In Sheets c.Visible = True Next c End Sub and run the macro On Thu, Nov 1, 2012 at 10:17 AM, amar takale wrote: > Hi All Champs, > Can anybody tell me how to unhide worksheets

Re: $$Excel-Macros$$ Recover Excel File

> > > On Thu, Nov 1, 2012 at 10:09 AM, अनिल नारायण गवली > wrote: > >> Yes Dear, >> Just goto Run type %appdata% >> in that goto Microsoft-> Excel >> there u'll find the old data . >> >> Regards, >> Anil Gawli >> >&g

Re: $$Excel-Macros$$ Fwd: VBA enabled sheet doesn't allow to protect

pls share that sheet with us On Fri, Nov 2, 2012 at 2:21 PM, Pravin Gunjal wrote: > *Still waiting for the reply. Thanks. > * > -- Forwarded message -- > From: Pravin Gunjal > Date: Thu, Nov 1, 2012 at 12:12 PM > Subject: $$Excel-Macros$$ Fwd: VBA enabled sheet doesn't allow to

Re: $$Excel-Macros$$ Macro

Pls find Attached FYI Regards, Gawli Anil. On Mon, Nov 5, 2012 at 11:52 AM, Aamir Shahzad wrote: > Dear Group, > > I need the macro when I run, it convert the number into comma style plus > decrease decimal to zero. > > e.g. 12345678.00 convert to 12,345,678 > > Aamir Shahzad > > -- > Join offi

Re: $$Excel-Macros$$ Macro

>> Hi, >> >> Use this shortkut key = alt+H+K >> >> >> >> On Mon, Nov 5, 2012 at 12:02 PM, अनिल नारायण गवली < >> gawlianil8...@gmail.com> wrote: >> >>> Pls find Attached >>> FYI >>> >>> Regards, >>>

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

Dear Rajan, Congrats Dear..keep going... Cheers. Regards Gawli Anil On Tue, Nov 6, 2012 at 9:58 AM, wrote: > ** > Congratulations ... Great going!!! > Sent on my BlackBerry® from Vodafone > -- > *From: * Ayush Jain > *Sender: * excel-macros@googlegroups.c

Re: $$Excel-Macros$$ inquiry

DELIN FRANCIS > *To:* "excel-macros@googlegroups.com" > *Sent:* Tuesday, 6 November 2012 12:11 PM > *Subject:* Re: $$Excel-Macros$$ inquiry > > Dear Anil, > > thank you very much > > Its wonder full man .... > > and were did you hide the picture > &

Re: $$Excel-Macros$$ VBA : Class does not support automation error.

Dear Amol , Pl share a sheet with group. Thanks & Regards, Gawli Anil On Fri, Nov 9, 2012 at 12:07 PM, Amol Jadhav wrote: > Hello Experts, > > > I need your expert advice. > > I created a tool using VBA form and OWC 10.0. I am exporting chart which > is on chartspace component(OWC 10.0). On so

Re: $$Excel-Macros$$ Code Problem

Dear Sajid, first see that from different pc can you access manually to that folder then see the details (the address) and confirm. Regards, Gawli Anil On Tue, Nov 13, 2012 at 2:50 PM, SAJID MEMON wrote: > I have shared it but it not open from other PC except main (Lenovo) > > >

Re: $$Excel-Macros$$ Code Problem

Dear Sajid, Just see if the extention is xls or xlsx or xlsm. and confirm Thanks & Regards Gawli Anil On Tue, Nov 13, 2012 at 2:57 PM, अनिल नारायण गवली wrote: > Dear Sajid, > > first see that from different pc can you access manually to that folder > then see the details (

Re: $$Excel-Macros$$ Re: Type Mismatch error.

Dear Prince, Pl share a sample workbook with us. Regards, Gawli Anil On Tue, Nov 20, 2012 at 8:42 AM, Prince wrote: > Hi Paul, > > These numbers of columns in my array.and i wanted to assign this columns > after transposing or after making it rows to a range. > > regards > Prince > > > On M

Re: $$Excel-Macros$$ Re: Split a cell into multiple cells in Excel 2010

dear Rakesh, Pl specify you query to understand better.Or share a sample workbook with us Regards, Gawli Anil On Wed, Nov 21, 2012 at 11:47 AM, Prince wrote: > Hi Rakesh, > > Do you want to split data of a cell into multiple cell or somthing else ??? > > Regards > Prince. > > On Wednesday,

Re: $$Excel-Macros$$ VBA & vlookup issue

Dear teow, can u share a workbook with us?? Regards, Gawli Anil On Wed, Nov 21, 2012 at 4:34 PM, Teow wrote: > > > when i use C:\test\[WSO_Record.xls]Record, the script can run propriety, > but if change to network path " & ThisWorkbook.Path & > "\[WSO_Record.xls]Record, i will get error 1004

Re: $$Excel-Macros$$ Lookup

Dear Yogi, first u have to set the page,custom setting then as u go to another workbook in the page setup u can user the last custom setting which u had set before. Regards, Gawli Anil On Thu, Nov 22, 2012 at 12:35 PM, yogiyogi123 wrote: > Hi all.. > i have a doubt in excel qt > G

Re: $$Excel-Macros$$ Re: Formula need to calculate sum on conditional base

pls share the workbook with us On Fri, Nov 30, 2012 at 12:16 PM, Ashish Bhalara wrote: > i need the formula for text enetered in sheet with red color > > On Fri, Nov 30, 2012 at 12:13 PM, Ashish Bhalara < > ashishbhalar...@gmail.com> wrote: > >> Dear expert, >> >> I have a data in attached sheet,

Re: $$Excel-Macros$$ Re: Formula need to calculate sum on conditional base

Pls find attched sheet for you reference. Regards, Gawli Anil On Fri, Nov 30, 2012 at 12:16 PM, Ashish Bhalara wrote: > i need the formula for text enetered in sheet with red color > > On Fri, Nov 30, 2012 at 12:13 PM, Ashish Bhalara < > ashishbhalar...@gmail.com> wrote: > >> Dear expert, >> >>

Re: $$Excel-Macros$$ Re: Formula need to calculate sum on conditional base

ed colour. > > > -- Forwarded message -- > From: अनिल नारायण गवली > Date: Fri, Nov 30, 2012 at 12:26 PM > Subject: Re: $$Excel-Macros$$ Re: Formula need to calculate sum on > conditional base > To: excel-macros@googlegroups.com, Ashish Bhalara < > ashishbhalar...@gmail.co

Re: $$Excel-Macros$$ Re: Paul Schreiner - Most Helpful Member November'12

congrats dear. Regards, Gawli Anil On Tue, Dec 4, 2012 at 12:00 PM, Rajan_Verma wrote: > Heartly Congrats Paul :) > > > On Monday, 3 December 2012 23:58:06 UTC+5:30, Ayush Jain wrote: >> >> Dear members, >> >> Paul Schreiner has been selected as 'Most Helpful Member' for the month >> of Nov'12.

Re: $$Excel-Macros$$ need formula help

Dear excellerner, Use $ sign to make constant row or column . for eg if u select A1 A10 then write $A$1 $A$10. first $ is for column and second $ is for row. you can use only one $ for only one column like $A1 or you can use only one row like a$1 . Regards, Gawli On Mon, Dec 10, 2012 at 12:31 PM,

Re: $$Excel-Macros$$ Help req.

Dear Neeraj, Pl find attached. Regards, Gawli On Wed, Dec 12, 2012 at 12:28 PM, neeraj chauhan wrote: > Dear Experts, > > kindly find the attached sheet. i want to make the conditional format, but > how to make. revert me > > -- > Join official Facebook page of this forum @ > https://www.facebo

Re: $$Excel-Macros$$ i want use pivot table in multi sheet of excel 2007

pls provid the sample data. Regards, Gawli Anil On Thu, Dec 13, 2012 at 12:10 PM, SHAIL GROUPS wrote: > Respected sir, >i want to use pivort table in multi sheet of excel > 2007 > > > > > > -- > > *[image: i love you]* > > ** > > **[image: -][image: -][image: -][image: -]

Re: $$Excel-Macros$$ Help Please

Dear Sanjay, U cannot give same name to two sheets. And while inserting the default name will be "Sheet and the number ". II'm guessing that u want the name while inserting a blank sheet . a name which is defined by U and not the excel program. If i'm guessing right then logic is *Sub AddWorkshe

Re: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner.

Congrats to my friends. Regards, Gawli Anil On Mon, Dec 17, 2012 at 7:37 AM, SHREYAS GUPTA wrote: > Sir, > If the above link is not working please use this link- > > > http://www.vertex42.com/Files/download/exclusive.php?file=yearly_event_calendar.xlsx > > Regards > Shreyas Gupta > > > > > On Mo

Re: $$Excel-Macros$$ Merry Christmas & Happy New Year

Wish U a Very Merry Christmas to all my forums friends. Regards, Gawli Anil On Wed, Dec 26, 2012 at 9:59 AM, Satendra kumar wrote: > > Merry Christmas > > > > On Tue, Dec 25, 2012 at 11:25 AM, Dhaval Shah wrote: > >> Merry Christmas > > > > > -- > Thanks & Regards > Satendra Kumar > > -- > Join

Re: $$Excel-Macros$$ Re: Need sumif formula with 2 conditions

Dear Rajesh , Pl attach the right workbook . Your attached workboon contains no data. Regards, Gawli Anil On Wed, Dec 26, 2012 at 9:17 PM, Prince wrote: > Hi Rajesh, > > There is no data in the sheet. > :( > > regards > Prince > > On Wednesday, December 26, 2012 5:28:24 PM UTC+5:30, kasper wr

Re: $$Excel-Macros$$ Fwd: Sales File

use =Today() on that cell which u want to change automatically. Regards, Gawli Anil On Thu, Dec 27, 2012 at 11:58 AM, rohit tharwani wrote: > Hie Experts , > PFA of Daily Consumer daily sales & i need urgent help from your side > ..in report sheet i have put formulas & in PTD 15feb 2012 in th

Re: [XL-VBA Clinic] Re: $$Excel-Macros$$ Amendment in macro

hey Noorian code is working f9. Regards, Gawli Anil On Fri, Dec 28, 2012 at 2:48 PM, Aamir Shahzad wrote: > Dear Noorain Sir and Group, > > Still waiting for recification of the query. > Aamir Shahzad > > -- Forwarded message -- > From: Aamir Shahzad > Date: Tue, Dec 18, 2012 a

Re: $$Excel-Macros$$ Re: Happy b'day Noorain Ansari

Dear Noorian, Wish U a very happy birthday:) Mag God bless u. Thanks, Gawli Anil On Wed, Jan 2, 2013 at 8:37 AM, Prince wrote: > Happay b. day Noorain Bhai. May god bless you lots of happiness ahead. > > Regards > Prince > > > > > On Wednesday, January 2, 2013 12:13:5

Re: $$Excel-Macros$$ Re: Happy b'day Noorain Ansari

On Wed, Jan 2, 2013 at 9:47 AM, अनिल नारायण गवली wrote: > Dear Noorian, > > Wish U a very happy birthday:) Mag God bless u. > > > Thanks, > Gawli Anil > -- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Service

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

Dear Manoj, If u want to remove only white space then use Substitute like given below. =SUBSTITUTE(A1," ","") Regards, Gawli Anil On Wed, Jan 2, 2013 at 12:15 PM, Prince wrote: > Hi Francis, > > This formula cut the string from first charactor up the number of numeric > value inside that text

Re: $$Excel-Macros$$ Lookup and Replace

PFA On Thu, Jan 3, 2013 at 10:27 AM, The Viper wrote: > slightly modified your code. > check the attachment > > > On Thu, Jan 3, 2013 at 8:47 AM, Awal wrote: > >> Hello, >> I would like to wish y'all a Happy New year... >> I am still learning VBA and I really need help: >> I want to be able to

Re: $$Excel-Macros$$ Slow processing of Data

Hi Hilary, As u r insered too-much formula it will hang the pc, because if u change any cells value of simply edit that cell the processor calculate all the fomula cell and hangsup. simple way is to copy the formula values and paste it as simple values. but from this it will not change the calcula

Re: $$Excel-Macros$$ how to lock worksheet

Dear Dhaval, Hide the formula bar which is availabale in options tab of workbook. Thanks & Regards, Gawli Anil On Fri, Jan 4, 2013 at 2:46 PM, Dhaval Shah wrote: > Dear friends > > i am lookking for solution 4 Lock work sheet if i am lock work sheet then > i m not able to use filter .

Re: $$Excel-Macros$$ Pivot table

PFA.. On Wed, Jan 9, 2013 at 1:27 PM, Anoop K Sharma wrote: > > Hope the attached file can help you better. > > Regards, > Anoop > Sr. Developer > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles.

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member December'12

heartly congratulations prince. Warm Regards, Gawli Anil On Fri, Jan 11, 2013 at 11:04 AM, NOORAIN ANSARI wrote: > Congrats Prince Babu... > > > -- > With Regards, > Noorain Ansari > http:// > noorainansari.com > http:// >

Re: $$Excel-Macros$$ HELP REQUIRED

Pl provide a meaningfull subject. Warm Regards, Gawli Anil On Fri, Jan 11, 2013 at 10:57 AM, joginder kumar wrote: > HI GUROPS MEMBER , > > > PLEASE HELP REGARDING THIS SHEET . > > -- > Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use

Re: $$Excel-Macros$$ Conditional Concatenate

Dear Satendrakumar, use this =CONCATENATE(A1&","&B1&","&C1&","&D1) if u want "," in between. or else share the workbook wit us. Warm Regards, Gawli Anil On Fri, Jan 11, 2013 at 11:45 AM, Satendra kumar wrote: > Dear Expert, > > Solve this query..i want automate colored range. if you have a

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

Hi Chaya, Welcome to our Groups.fell free at any time to ask regarding about excel. Warm Reagrds, Gawli Anil On Fri, Jan 11, 2013 at 3:08 PM, Prince wrote: > Hi Chaya, > > Welcome in the group :) > > > Regards > Prince > > > On Friday, January 11, 2013 3:01:45 PM UTC+5:30, chaya moni wrot

$$Excel-Macros$$ Hey how to recover source data from pivot table .

Dear All, actually my bro has deleted the source data. befor he has deleted i had made a pivot table after that he deleted the souce data. Now i want that data back . is there any solutions. -- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Join

Re: $$Excel-Macros$$ Hey how to recover source data from pivot table .

cache data from there. > > Regards, > Anoop > > > On Mon, Jan 14, 2013 at 12:05 PM, अनिल नारायण गवली < > gawlianil8...@gmail.com> wrote: > >> Dear All, >> >> actually my bro has deleted the source data. befor he has deleted i had >> made a piv

Re: $$Excel-Macros$$ Hey how to recover source data from pivot table .

sn't work then there is no hope to retrieve all the data. > > Good luck > > > > On Mon, Jan 14, 2013 at 2:16 PM, अनिल नारायण गवली > wrote: > >> dear , >> But it only shows that much data the field which i have clicked . I want >> all the data. >> &

Re: $$Excel-Macros$$ Re: formula required

pl share a worksheet with us On Tue, Jan 15, 2013 at 1:45 PM, wrote: > ** > Hi prince > > > Will you please help me. > I have three different excel file and each excel file have three different > wrk sheet. I need to link or copy all data in one excel file from these > different wrk sheet. How d

Re: $$Excel-Macros$$ Re: Need Formula

pl find attached herewith. Warm Regards, Anil Gawli On Tue, Jan 15, 2013 at 1:07 PM, Prince wrote: > Hi Prabhakar, > > paste the following formula. > > =SUMIFS(C2:C10,A2:A10,"Fax",B2:B10,"Brown") > > Regards > Prince > > > On Tuesday, January 15, 2013 12:40:13 PM UTC+5:30, Prabhakar S H wrote:

Re: $$Excel-Macros$$ SAN FRANCISCO EXCEL VBA PROGRAMMER/DEVELOPER

I'm ready.. dear. Warm regards, Gawli Anil On Wed, Jan 16, 2013 at 12:31 AM, TJ wrote: > I am reaching out with the hopes of networking with VBA Excel programmers > in the San Fran area.If you know of anyone looking for an opportunity to > work on a project for a corporation please let me know.

Re: $$Excel-Macros$$ Allocation problem between Requirement and Stock.

Pls find attached , Is it ok???/ Thanks & Reagards, Gawli Anil On Tue, Jan 15, 2013 at 4:37 PM, Eugene Bernard wrote: > Dear all, > > Please find attached an excel workbook, having 2 sheets. In this "REQT" > sheet, I need to fill in the column "C" with the quantities available from > Stock shee

  1   2   3   >