$$Excel-Macros$$ Macro Help

Dear Team, Please amend macro in attached sheet to automatically select range based on cell value. Thx in advance Regards, Prashant -- 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 @

$$Excel-Macros$$ formula required

Dear Team, Need a formula to look up a filed give sum of figure , sample file attached Regards, Prashant -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

$$Excel-Macros$$ Macro /Formula to Merge Text

Dear Experts, Please let me know any formula or macro to merge text together . Query is it should conditionally merge text. In the Sample file attached , I want Col C texts are merged in Col D, as long as there is no data in Col A Regards PP -- Join official Facebook page of this forum @

$$Excel-Macros$$ Edit Link Code -support

Dear all, I need to know how convert below code , so that any file path get replaced by below code ActiveWorkbook.ChangeLink Name:= c:\USER\app\Management Level Adj..xlsm _ , NewName:=Management Level Adj..xlsm, Type:=xlExcelLinks Regards, Prashant -- Join official Facebook page

$$Excel-Macros$$

= c:\Attachments 'The subject for the outgoing e-mails. Const stSubject As String = Group MIS 'The message in the bodies of the outgoing e-mails. Const vaMsg As Variant = Group MIS Report as per agreement. vbCrLf _ Kind regards, vbCrLf _ Prashant Pawle| CORP-MIS 'Variable

Re: $$Excel-Macros$$ VBA CODE REQUIRED

As Range Set wk = ActiveSheet For Each cl In wk.UsedRange.Columns If IsNumeric(cl.Cells(2, 1).Value) And Left(cl.Cells(2, 1).Text, 1) = # Then MsgBox cl.Address(0, 0) End If Next End Sub On Sun, Nov 11, 2012 at 1:23 PM, Prashant Pawle ppawle.ex...@gmail.comwrote: Dear

$$Excel-Macros$$ VBA CODE REQUIRED

Dear Team, Need a code for listing cell references from all sheets which have too narrow column width(#). Sample file attached Regards, Prashant -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation)

$$Excel-Macros$$ Serial no

Dear Experts Please help to arrive serial number with if condition Regards, Prashant -- 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$$ Code for combining PDF files thru VBA

Dear Team, Kindly help on Code for combining multiple PDF files thru VBA regards, Prashant -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need

Re: $$Excel-Macros$$ Need formula

sheet. On Thu, Jul 12, 2012 at 4:50 PM, Prashant Pawle ppawle.ex...@gmail.comwrote: Dear All, Need a formula for getting first text in the Range, in particular cell , sample file attached Regards, Prashant -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise

Re: $$Excel-Macros$$ Find Narrow Cells Appying Auto fit to only that cell

. ** ** Regards David Grugeon On 16 June 2012 18:10, Prashant Pawle ppawle.ex...@gmail.com wrote: Dear Team, ** ** Please help of some macro to find Narrow Cells Appying Auto fit to only that cell , sample sheet attached ** ** Regards, ** ** Prashant

$$Excel-Macros$$ Find Narrow Cells Appying Auto fit to only that cell

Dear Team, Please help of some macro to find Narrow Cells Appying Auto fit to only that cell , sample sheet attached Regards, Prashant -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

Fwd: $$Excel-Macros$$ Extract Data Macro Help

Dear All, Please help on below mail Regards, Prashant -- Forwarded message -- From: *Prashant Pawle* Date: Wednesday, June 6, 2012 Subject: $$Excel-Macros$$ Extract Data Macro Help To: excel-macros@googlegroups.com excel-macros@googlegroups.com Dear Experts, I am trying

Fwd: $$Excel-Macros$$ Extract Data Macro Help

Dear Experts, Please Help Regards, Prashant -- Forwarded message -- From: Prashant Pawle ppawle.ex...@gmail.com Date: Wed, Jun 6, 2012 at 5:27 PM Subject: $$Excel-Macros$$ Extract Data Macro Help To: excel-macros@googlegroups.com excel-macros@googlegroups.com Dear Experts

$$Excel-Macros$$ Extract Data Macro Help

Dear Experts, I am trying to extract data from multiple files with helpof macro. I have set data copy parameters in another sheet so that when I change reference of sheets cells my macro should work accordingly. But I am unable to finish the code, please help Regards, Prashant -- FORUM

$$Excel-Macros$$ MACRO FOR DATA SORT

Dear Experts, Kindly advise macro to sort data by dt of openingMacro shd run if the range of data is changed Thanks in advance Regards, Prashant -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

$$Excel-Macros$$ Macro for data sorting

Dear Experts, Please ignore previous mail , correct file attached here , please help on below Kindly advise macro to sort data by dt of openingMacro shd run if the range of data is changed Thanks in advance Regards, Prashant -- FORUM RULES (986+ members already BANNED for violation)

Re: $$Excel-Macros$$ Macro for data sorting

, MatchCase:=False, Orientation:=xlTopToBottom, _* *DataOption1:=xlSortNormal* *End Sub* See attached Sheet. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 8, 2012 at 12:42 PM, prashant pawle pawleprash...@gmail.comwrote

$$Excel-Macros$$ Cell Lock

Dear Manish, I tried the same, but my objective is not to allow users to use filter of the cell A1, they may use any of the visible cell except A1 Please advise further Regards, Prashant | Manish Purohit to excel-macros show details 8:25 AM (10 hours ago) Reply [image: Follow up message]

$$Excel-Macros$$ Help please

Dear All Excel Gurus, Kindly help on the problem in the attached sheet. I need formula for ranking , punches as per day/time Regards, Prashant --~--~-~--~~~---~--~~ -- Some

$$Excel-Macros$$ Cell Lock

Dear All, In the attached sheet advise how to lock onlu one cell (Yellow highlighted) from editing or filtering Thanks in advance Regards, -- Prashant --~--~-~--~~~---~--~~ -- Some