$$Excel-Macros$$ Re: Urgently multiple if condition required in excel

Hi Dharti kumar, Please explain it more regards prince On Thursday, October 4, 2012 11:44:01 AM UTC+5:30, Dhartikumar Sahu wrote: > > hi Group > > Can u please help me out in this problem. I have an query of Multiple if > conditions > > if % Column true then result will be shown in solution.

$$Excel-Macros$$ Need Help in allocation table

Need help Dear All, I need your help in automatic some calculations in spreadsheet. I have data in excel as below; It consists of 2 parts. first part is Expense statement and second part is allocation required. The expense statement has data period for each type of expenditure. The same ne

$$Excel-Macros$$ Urgently multiple if condition required in excel

hi Group Can u please help me out in this problem. I have an query of Multiple if conditions if % Column true then result will be shown in solution. % if Solution 37 >50 – 55% 0.55 50.3 >55 – 60% 0.6 50.09 >60 – 65% 0.65 62.43 >65 – 70% 0.7 68.39 >70 – 75% 0.75 30.43 >75 – 80% 0.8 50

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

$$Excel-Macros$$ How to repair corrupted Excel file

Dear Friends & Excel Experts, I have a Excel 2007 file of around 5 MB (which I saved in binary format. Last week it suddenly got corrupted and I am now unable to open it , While opening it says "The work book cannot be opened or repaired by MS Excel because it is corrupt" Please help me in this

$$Excel-Macros$$ Re: Help on Macro

I have re read your post several times and looked at your file and I have NO idea what you want. On Friday, September 28, 2012 5:48:22 AM UTC-5, shrini wrote: > > Dear All > Can Any one help me to write a macro for following things. > > In sheet 1 I have more than 200 items.I want to make a sam

$$Excel-Macros$$ Dual Monitors

I am constantly moving my excel window from 1 screen to another. Does anyone know of vba code that would switch the excel window from one monitor to another? Thanks - Michael -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members alread

$$Excel-Macros$$ Re: Help - To create chart based on the chart type select by using VBA

Hi Mangesh, I feel the data you have provided is not suitable for the all the chart type that you have mentioned into your sheet. pls confirm us the logic by which your chart should be displayed . regards prince On Wednesday, October 3, 2012 6:39:04 PM UTC+5:30, Mangesh wrote: > > Hi Frien

RE: $$Excel-Macros$$

Date2 Must be greater than Date1 Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: 03 October 2012 6:59 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Hello,

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

*@ Krishna, waiting for your reply. :)* On Wed, Oct 3, 2012 at 1:13 AM, Indrajit $nai wrote: > *@ Krishna, no Sir; still showing the same error! > * > > > > On Tue, Oct 2, 2012 at 9:26 PM, Krishna Kumar wrote: > >> .Range("b" & LastRow).Resize(, 4) = Split(Me.TextBox2.Value & "|" & >> M

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

Hi , I am Arvind, I am currently working for Value Labs. Before this i was working for IBM for 3 years. For NAAC (National Assessment and Accreditation Council) for 2 years. I have done by Graduation in Electronics and done 2 years of GNIIT course (Computer System Management). Thanks and Regard

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

NOW we're getting somewhere. Keep in mind that you've asked the question in an EXCEL Macros group. It's kind-of like calling a Plumber and asking him to come and fix a leak. When he arrives, he finds that the leak is in the ROOF. Of course he MAY be able to fix it, but that's not his primary pur

Re: $$Excel-Macros$$ Help - To create chart based on the chart type select by using VBA

Hi Rajan, Its sample data I have provided but the data range would remain same. Please provide solution. Thanks !!! On Wed, Oct 3, 2012 at 6:43 PM, Rajan_Verma wrote: > *Is your data suitable for all chart type ? * > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]*

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

My question is a bit different but will help resolve this issue. What is the file extension of the files in the folder? Regards David Grugeon On 3 October 2012 22:24, Paul Schreiner wrote: > OK... I'm going to try one more time. > Please be CLEAR. > > Are the folders IN OUTLOOK? > > > Paul > >

RE: $$Excel-Macros$$ Help - To create chart based on the chart type select by using VBA

Is your data suitable for all chart type ? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mangesh Vimay Sent: 03 October 2012 6:39 To: excel-macros@googlegroups.com; Mangesh Vimay Subject: $$Excel-M

RE: $$Excel-Macros$$

=B2-A2 Apply [m] as custom format Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: 03 October 2012 6:34 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Hell

Re: $$Excel-Macros$$

Please try =TEXT(TEXT(A2,"hh:mm")-TEXT(B2,"hh:mm"),"hh:mm") On Wed, Oct 3, 2012 at 6:33 PM, Chandra Shekar wrote: > Hello, > > Could you please help me in the attached file. > > Thanks in advance. > > Regards, > > Chandra Shekar B > > > > -- > Join official facebook page of this forum @ > https

$$Excel-Macros$$ Help - To create chart based on the chart type select by using VBA

Hi Friends, I need to create a chart based on the chart type selected from the drop down list (created by data validation). The sample data is being provided in the sheet. Every time when we create the chart previous chart should get deleted. [Find the attachment]. Please do it by using VBA. Tha

$$Excel-Macros$$

Hello, Could you please help me in the attached file. Thanks in advance. Regards, Chandra Shekar B -- 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 thre

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

Thanks to all. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 03 October 2012 5:14 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Mem

Re: $$Excel-Macros$$ Re: Help on Macro

Please find attached sheet Thanks in advance On Wed, Oct 3, 2012 at 6:00 PM, Don Guillett wrote: > Provide a file with this to dguillett1 @gmail.com > > > On Friday, September 28, 2012 5:48:22 AM UTC-5, shrini wrote: >> >> Dear All >> Can Any one help me to write a macro for following things. >>

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

now i have a folder in outlook, folder contain many mail, every mail has a attachment with same name. i want to save all attachment in my desktop folder with different name.. On Wed, Oct 3, 2012 at 5:54 PM, Paul Schreiner wrote: > OK... I'm going to try one more time. > Please be CLEAR. > > Are

$$Excel-Macros$$ Re: Help on Macro

Provide a file with this to dguillett1 @gmail.com On Friday, September 28, 2012 5:48:22 AM UTC-5, shrini wrote: > > Dear All > Can Any one help me to write a macro for following things. > > In sheet 1 I have more than 200 items.I want to make a sample by choosing > items from this list. > > 1

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

OK... I'm going to try one more time. Please be CLEAR. Are the folders IN OUTLOOK?   Paul - “Do all the good you can, By all the means you can, 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 a

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

I can say only... यूँ ही बरकरार रखो भाई अपने Expertise के छाप को. और अपनी तरक्की से छोटा कर दो आसमा के माप को. हम दोस्तों की दुआए,सदा संग बन के रहे साए... मेरे ओर से लाख-लाख बधाई, राजन बाबु आपको. -- With Regards, Noorain Ansari http:// noorainansari.

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

Sorry for delay i have outlook mail save in folder every mail has excel attachment... i want to extract all excel in onether folder.. Regard Manoj On Wed, Oct 3, 2012 at 4:57 PM, Paul Schreiner wrote: > Are you saying that the folders are IN Outlook? > Not on your filesystem? > (that is li

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

Are you saying that the folders are IN Outlook? Not on your filesystem? (that is like "C:\temp\X")   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you

Re: $$Excel-Macros$$ Hours Calculation Project

here is my co-operation on your project pfa On Wed, Oct 3, 2012 at 1:38 PM, SAJID MEMON wrote: > Dear Expert, > > I require your co-operation to complite my project. I have attached a > require file in excel 2003. Please give me details with code to complite my > project. > > Awiting your posit

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

Hi Manoj, I hope this will help you. Sub Copy_Folder() Dim FSO As Object Dim FromPath As String Dim ToPath As String FromPath = "K:\Prince\Rima" '<< Change ToPath = "K:\Prince\test"'<< Change If Right(FromPath, 1) = "\" Then FromPath = Left(FromPath,

$$Excel-Macros$$ Hours Calculation Project

Dear Expert, I require your co-operation to complite my project. I have attached a require file in excel 2003. Please give me details with code to complite my project. Awiting your positive responce Regards Sajid Memon -- Join official fac

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

Dear vabz, Thanks. but it's not working.. Regard Manoj On Wed, Oct 3, 2012 at 1:15 PM, Vabz wrote: > Hi > > PFA Files.. > > Cheers.. > > Rgds//Vabs > > On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote: >> >> Dear Export, >> >> I have one folder "x" witch has contain mail'

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

Hi Prince, X is my folder name witch has many mail's of outlook..every mail has a excel attachment.. Regard Manoj On Wed, Oct 3, 2012 at 12:52 PM, Prince Dubey wrote: > Hi Manoj, > > I their any sub folder inside forlder X ? > > > Regards > Prince > > On Wednesday, October 3, 2012 12:47:18 PM U

$$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

Hi Manoj, I their any sub folder inside forlder X ? Regards Prince On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote: > > Dear Export, > > I have one folder "x" witch has contain mail's, every mail contain an > excel file, > i want to copy all excel file from folder "x" to

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

I'm happy to see you recognized and honored for your continued great contribution Rajan. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: Tuesday, October 02, 2012 8:34 AM To: excel-macros Subject: $$Excel-Macros$$ Rajan Verma - Most

$$Excel-Macros$$ Excel Macro Reqd for Folder to Folder

Dear Export, I have one folder "x" witch has contain mail's, every mail contain an excel file, i want to copy all excel file from folder "x" to onther folder with different name.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1

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

Dear Friend, Rajan Congratulations to you for u r successful efforts. Keep the same track and be the no. 1 always. Excellent works! Praises & Prosperity, Muneer, CC... On Wed, Oct 3, 2012 at 10:36 AM, Karan Singh wrote: Congrats dude! Karan Singh On Wed, Oct 3, 2012 at