$$Excel-Macros$$ Open closed chart

2013-07-14 Thread Rajan sharma
Dear All, How can we plot the data below in chart. i am expecting the chart as like in attached file. plse find the attachment. Type Total Open Total Closed Total Count A 6 3 9 B 2 2 4 With warm regards, Rajan Sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

Re: $$Excel-Macros$$ New here

2013-07-14 Thread Deepak Singh
Thanks Priti and DP i am also feeling the same to see you type of great Excel Experts in this group. now i can say I will enjoy in this group and give all my support. -- 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

Re: $$Excel-Macros$$ Amazing Excel Charts

2013-07-14 Thread Rajan sharma
Dear Ashish sir, Can you please share me the excel fil. Actually i am unable to download the file from the mention site. i am eager to see the chart. With warm regards, Rajan Sharma On Sat, Jul 13, 2013 at 3:11 PM, Puttu * wrote: > really very useful. Thanks > > > On Sat, Jul 13, 2013 a

Re: $$Excel-Macros$$ Finding text within data

2013-07-14 Thread De Premor
PFA On 09/07/2013 1:43, ha...@mst.edu wrote: Hi All, Basically, I want to find a text from specific category and return the text/number to a specific cell. For example, API NUMBER: (return the value here) Find API number from the following text(be aware:API # is always 10 numbers separated by

Re: $$Excel-Macros$$ I want to merge two text cell

2013-07-14 Thread Prabhu Pinky
Hi Dhaval Pls find attached file with solution. Thanks & Regards, Prabhu R *From:* Dhaval Shah > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, 6 March 2013 5:21 PM > *Subject:* $$Excel-Macros$$ I want to merge two text cell > > dear friends > > i want to merge two text cell in one

Re: $$Excel-Macros$$ New here

2013-07-14 Thread priti verma
Most welcome Deepak. On Sun, Jul 14, 2013 at 5:59 PM, De Premor wrote: > Hi Deep, glad to see you here too > > Rgds, > [dp] > > Pada 14/07/2013 19:27, Deepak Singh menulis: > > *I am Deepak Singh, i have been referred to this group by one of my > friend who is already part of this group. I am

Re: $$Excel-Macros$$ Stock Query

2013-07-14 Thread Chandra Gupta
Hi Sajid, Please find attached solution for your query. Regards Chandra Gupta Maurya On Sat, Jul 13, 2013 at 7:48 PM, Anil Kumar wrote: > Hi > pfa > > -- > *From:* SAJID MEMON > *To:* Sundarvelan Natarajan > *Sent:* Saturday, 13 July 2013 6:24 PM > *Subject:

Re: $$Excel-Macros$$ New here

2013-07-14 Thread De Premor
Hi Deep, glad to see you here too Rgds, [dp] Pada 14/07/2013 19:27, Deepak Singh menulis: /*I am Deepak Singh, i have been referred to this group by one of my friend who is already part of this group. I am also part of some other Excel Forumn. Hope i will learn many thing from this group and g

$$Excel-Macros$$ New here

2013-07-14 Thread Deepak Singh
*I am Deepak Singh, i have been referred to this group by one of my friend who is already part of this group. I am also part of some other Excel Forumn. Hope i will learn many thing from this group and get solution from all experts related to my Excel related issues. Thanks & Regards Deepak Si

Re: $$Excel-Macros$$ Help needed

2013-07-14 Thread thameem
thank you it working On Sun, Jul 14, 2013 at 3:58 PM, ashish koul wrote: > try this > Sub check_files_to_open() > > Dim flname As String > > flname = InputBox("Enter file to search") > Set fso = CreateObject("scripting.filesystemobject") > Set fld = fso.getfolder("C:\Users\admin

Re: $$Excel-Macros$$ Help needed

2013-07-14 Thread ashish koul
try this Sub check_files_to_open() Dim flname As String flname = InputBox("Enter file to search") Set fso = CreateObject("scripting.filesystemobject") Set fld = fso.getfolder("C:\Users\admin\Desktop\New folder") For Each fil In fld.Files If UCase(Left(fil.Name, InStrR

Re: $$Excel-Macros$$ Help needed

2013-07-14 Thread thameem
sorry again not working, its asking to select folder, later file name, if i type file name, its actually pdf format but opening in excel format. cant we fix folder path in this program, so there is no need to select folder every time On Sun, Jul 14, 2013 at 11:57 AM, ashish koul wrote: > hi

Re: $$Excel-Macros$$ Help needed

2013-07-14 Thread ashish koul
hi try this Sub check_files_to_open() Dim fldpath Dim fld As Object, fil As Object, fso As Object Dim flname As String With Application.FileDialog(msoFileDialogFolderPicker) .Title = "Choose the folder" .Show End With flname = InputBox("Enter file to search") On Error Resume Next fldpath = App

Re: Fw: Fw: $$Excel-Macros$$ small macro help

2013-07-14 Thread ashish koul
easiest way is simply move this tab or copy the content of the tab to your workbook and code too In case u change the name of sheet .please change it in code too Sheets("Plan").Select 6th line Regards Ashish Regards Ashish On Sun, Jul 14, 2013 at 1:04 PM, shreya vyas wrote: > > Hey, ashi