$$Excel-Macros$$ renaming of pdf files

2015-07-10 Thread Siraj Momin (BHOG)
Dear Sir, The attached file was posted on this group before for renaming of pdf files, by mr. Mandeep Baluja but it is not working in my case What I want is first it should get the list of file from particular folder then I will put new name against each file in excel sheet it should rename ac

$$Excel-Macros$$ FW: Auto Generating Report - TOP MOST URGENT

2015-07-10 Thread KANNAN V
Top most urgent, pls help me... -Original Message- From: "Kannan V" Sent: ‎11-‎07-‎2015 10:39 AM To: "kannan.ex...@gmail.com" Subject: Auto Generating Report - TOP MOST URGENT Dear Sir, Please find the attached file and do the needful urgent basis... Regards Kannan V -- Are you

FW: $$Excel-Macros$$ Re: FW: Automatically Generating Report - URGENT

2015-07-10 Thread KANNAN V
-Original Message- From: "KANNAN V" Sent: ‎11-‎07-‎2015 09:26 AM To: "KANNAN V" ; "vt_kan...@camsonline.com" Subject: RE: $$Excel-Macros$$ Re: FW: Automatically Generating Report - URGENT Hi Bro, Really thanks for your effect, but its not working. Pls check below mentioned result.

$$Excel-Macros$$ Query in VBA

2015-07-10 Thread Soumyendu Paul
Dear All, My query for attached file When we select data from drop down A cursor to move A6;when we select B from drop down cursor move down B13 -- 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

Re: $$Excel-Macros$$ Change the date in required format in macro and store in variable

2015-07-10 Thread Sunil Kumar Yadav
Welcome! -- Thanks & Regards *Sunil Kumar Yadav* Skype ID: sunil.yadav7186 On Fri, Jul 10, 2015 at 12:14 PM, Ganesh N wrote: > Thanks bro > > Regards, > GN > > On Thu, Jul 9, 2015 at 1:45 PM, Sunil Kumar Yadav > wrote: > >> PFA >> >> -- >> Thanks & Regards >> *Sunil Kumar Yadav* >> Skype ID: s

Re: $$Excel-Macros$$ Re: FW: Automatically Generating Report - URGENT

2015-07-10 Thread Mandeep Baluja
Code Changed !! Try this Check this Out. Regards, Mandeep Baluja Email :-mandeep.bal...@snapdeal.com mandeep.bal...@gmail.com https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77 https://www.facebook.com/groups/825221420889809/ > Sub Createdata() > > Lc = Sheets("Sheet3").Cells(Rows.Count,

RE: $$Excel-Macros$$ Re: FW: Automatically Generating Report - URGENT

2015-07-10 Thread KANNAN V
Bro, Its not standard for 5rows. It's depends on requirement. And I wrongly raised my query. Sorry. -Original Message- From: "Mandeep Baluja" Sent: ‎10-‎07-‎2015 02:48 PM To: "excel-macros@googlegroups.com" Subject: Re: $$Excel-Macros$$ Re: FW: Automatically Generating Report - URGEN

$$Excel-Macros$$ FW: Automatically Generating Report - URGENT

2015-07-10 Thread KANNAN V
Dear Mandeep Baluja ji, Pls find the below mail and help me urgent basis. In my first mail, I am only wrongly mentioned 5rows. Regards Kannan V -Original Message- From: "Kannan V" Sent: ‎10-‎07-‎2015 03:29 PM To: "rockerna...@gmail.com" Cc: "kannan.ex...@gmail.com" Subject: Automatic

$$Excel-Macros$$ Re: Please Point error in following UDF

2015-07-10 Thread Mandeep Baluja
use this udf > Function allthebest(Rng As Range) > > Set c = Rng > k = -1 * c.Value > k1 = c.Offset(-c + 1, -5).Address > Set j = Range(k1, c.Offset(0, -5)) > allthebest = Application.WorksheetFunction.Average(j) > > End Function > > Check this Out. Regards, Mandeep Baluja Email :-mandeep.ba

Re: $$Excel-Macros$$ Re: FW: Automatically Generating Report - URGENT

2015-07-10 Thread Mandeep Baluja
Try once again. Or paste this in sheet 3 and and run the macro result will come in sheet 2 okay S NO CODE SLAB LOCATION TYPE STEP 1 k01v 1,2 T,B Normal , Sip STEP - 1 2 y02k 1,2 T,B Normal , Sip STEP - 2 3 n01p 2 B Sip STEP - 3 4 j55s 1 T Normal STEP - 4 On Friday, July 10, 2015

RE: $$Excel-Macros$$ Re: FW: Automatically Generating Report - URGENT

2015-07-10 Thread KANNAN V
Than of ur reply Bro, I am using excel 2010. In my company mail, ur attachment has not open. It's showing 'the file is corrupt and cannot opened'. -Original Message- From: "Mandeep Baluja" Sent: ‎10-‎07-‎2015 01:44 PM To: "excel-macros@googlegroups.com" Subject: $$Excel-Macros$$ Re: FW

$$Excel-Macros$$ Re: FW: Automatically Generating Report - URGENT

2015-07-10 Thread Mandeep Baluja
Regards, Mandeep Baluja Run this code output will receive in sheet2 and the criteria to get the result is pasted in sheet3. Sub Createdata() Lc = Sheets("Sheet3").Cells(Rows.Count, 1).End(xlUp).Row Sheets("Sheet2").Cells.ClearContents a = 5 b = 5 For a1 = 2 To Lc v = Split(Sheets("Shee