Re: $$Excel-Macros$$ DATA LINKAGE PROBLEM

2013-02-25 Thread Bé Trần Văn
Menu> Toosl> Macro> Macro and click Run to view the results 2013/2/23 Nitin Gupta > Hi > I want to link multiple data in row to column, but when you use transpose > function the links are not working need to past special in value term > > Sample Sheet attached > Please advice > > -- > Are you =E

Re: $$Excel-Macros$$ PDF attachment in Excel Cell

2013-02-25 Thread ANKUR AGGARWAL
Hi Anil, VBA code is password protected. Also, I am interested to know, how this is possible, can you briefly explain, how you did the same.  Thanks !   Warm Regards Ankur Aggarwal Analyst From: अनिल नारायण गवली To: excel-macros@googlegroups.com; ankur9_aggar

Re: $$Excel-Macros$$ URGENT PLS HELP ME IN EXCEL WORK

2013-02-25 Thread kannan excel
hi, STEP1: sheet 1 and sheet 2 is different clients, sheet 3 is data typing place. First concept is when i type client Name in sheet 3 means automatically that client rate want to come. example: already i should entered client rates. when i type that clinent name automatically that client rate wan

Re: $$Excel-Macros$$ PDF attachment in Excel Cell

2013-02-25 Thread amar takale
Dear, Thanks everybody who reply me for help, I was thinking it not possible but after guideline from my group member now I can say it is possible & I am also appreciated to member that there are any other way. If I hyperlink in excel more file PDF (min 50 files) then there is no issue File SIZE in

Re: $$Excel-Macros$$ URGENT PLS HELP ME IN EXCEL WORK

2013-02-25 Thread अनिल नारायण गवली
Dear Kannan, Pl eaborate your query?? Warm Regards, Gawli Anil On Tue, Feb 26, 2013 at 11:59 AM, kannan excel wrote: > Hi, > > Pls find the attachment. here i enclosed my sample data. i want solution > for anyway like vb coding or formula > > regards > kannan > > -- > Are y

Re: $$Excel-Macros$$ PDF attachment in Excel Cell

2013-02-25 Thread अनिल नारायण गवली
Dear Ankur, Whr u find password protected. the workbook which i have provided is not protected. My be the url of the first cell of that icon will be not available, because the url is from my desktop that's why. Warm Regards, Gawli Anil. On Tue, Feb 26, 2013 at 11:47 AM, ANKUR AGGARWAL < ankur9

Re: $$Excel-Macros$$ PDF attachment in Excel Cell

2013-02-25 Thread ANKUR AGGARWAL
How is it working ?, Also the code is password protected, can you please share the password ?   Warm Regards Ankur Aggarwal 91-8010614628 Analyst Mckinsey Knowledge Center Mckinsey & Co. From: अनिल नारायण गवली To: excel-macros@googlegroups.com; amar takale S

Re: $$Excel-Macros$$ Macro to create muliple sheets from excel

2013-02-25 Thread अनिल नारायण गवली
Dear Deepak, Pl elaborate some more . unable to understand your required query. Warm Regards, Gawli Anil. On Tue, Feb 26, 2013 at 11:27 AM, Deepak Rawat wrote: > Hi, > > I have attached 2 sheets: 1-Form 2-data > I need to create multiple sheets of the form, as much is data exists. > and dat

$$Excel-Macros$$ Macro to create muliple sheets from excel

2013-02-25 Thread Deepak Rawat
Hi, I have attached 2 sheets: 1-Form 2-data I need to create multiple sheets of the form, as much is data exists. and data should fill accordingly in each form. Regards, Deepak -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official F

Re: $$Excel-Macros$$ PDF attachment in Excel Cell

2013-02-25 Thread The Viper
you can attach it as an object On Tue, Feb 26, 2013 at 9:40 AM, अनिल नारायण गवली wrote: > Dear Amar, > > Yes it is possible with hyperlink > > just give the right url and save it. > > Pl see the attached sheet. > > Warm Regards, > Gawli Anil. > > On Mon, Feb 25, 2013 at 7:28 PM, Anil B wrote: >

Re: $$Excel-Macros$$ PDF attachment in Excel Cell

2013-02-25 Thread Anil B
listen for this one to attach the PDF Files u just need to hyperlink the file from desktop or file thats it u got the solution when u click it opens the file. Thanks, Anil On Mon, Feb 25, 2013 at 7:28 PM, Anil B wrote: > Hi dude, > > > > > On Mon, Feb 25, 2013 at 7:23 PM, amar takale wrote: >

Re: $$Excel-Macros$$ PDF attachment in Excel Cell

2013-02-25 Thread Anil B
Hi dude, On Mon, Feb 25, 2013 at 7:23 PM, amar takale wrote: > Dear All Experts, > > Discuss to all about PDF attachment in Excel Cell > > Regards > Amar > > > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page

$$Excel-Macros$$ PDF attachment in Excel Cell

2013-02-25 Thread amar takale
Dear All Experts, Discuss to all about PDF attachment in Excel Cell Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, a

$$Excel-Macros$$ Re: Sum with maximum

2013-02-25 Thread B Sharma
Please try the simplest one... =SUMIF(C2:C15,"<="&6500)+COUNTIFS(C2:C15,">6500")*6500 On Saturday, February 23, 2013 4:06:15 PM UTC+5:30, Ranjeet Negi wrote: > > Dear Sir, > > I have a data in Range (C2:C50). There are values. I want to sum all > value upto or equal to 6500, wherein values gre

Re: $$Excel-Macros$$ Assignment

2013-02-25 Thread NOORAIN ANSARI
Dear Harkesh, Please try it.. Function special_Charcters(rng As Excel.Range) Dim i As Integer Dim j As Integer For i = 1 To Len(rng) If Not Mid(rng, i, 1) Like "[0-9,A-Z,a-z]" Then special_Charcters = special_Charcters & Mid(rng, i, 1) End If Next i End Function Function Only_Numbers(rng As