$$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 @ https://www.face

$$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 @ http

$$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 pa

$$Excel-Macros$$

tPath As String = "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 & _

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

s 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:

$$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, like

$$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 A

Re: $$Excel-Macros$$ Need formula

> see attached sheet. > > > On Thu, Jul 12, 2012 at 4:50 PM, Prashant Pawle wrote: > >> Dear All, >> >> Need a formula for getting first text in the Range, in particular cell , >> sample file attached >> >> Regards, >> >> Prashant

$$Excel-Macros$$ Need formula

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, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Proble

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

inting. > ' We don't know for sure which worksheets are printing, so > ' SizeColumns for all of ThisWorkbook's Worksheets. > For Each Sheet In Me.Worksheets > SizeColumns Sheet > Next Sheet > > End I

$$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 H

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

Dear Experts, Please Help Regards, Prashant -- Forwarded message -- From: Prashant Pawle Date: Wed, Jun 6, 2012 at 5:27 PM Subject: $$Excel-Macros$$ Extract Data Macro Help To: "excel-macros@googlegroups.com" Dear Experts, I am trying to extract data from mult

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" Dear Experts, I am trying to extract data fro

$$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 RUL

$$Excel-Macros$$ Remove this mail id

Dear Team, Please remove my this id from mailing list ,I am adding another email id for this groups mails. 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 Prob

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

t; *OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _* > *DataOption1:=xlSortNormal* > *End Sub* > > See attached Sheet. > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > O

$$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 opening & Macro shd run if the range of data is changed Thanks in advance Regards, Prashant -- FORUM RULES (986+ members already BANNED for violation) 1

$$Excel-Macros$$ MACRO FOR DATA SORT

Dear Experts, Kindly advise macro to sort data by dt of opening & Macro 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, Urge

$$Excel-Macros$$ Re: Best Tip (Excel POP up Calendar)

It is under Developer tab>Insert> Active X Control>Calendar control 12.0 If u dont see Developer tab, then go to excel options>Populer>Developer Tab to activate the same Regards, Prashant On Mon, Aug 17, 2009 at 6:21 PM, big smile wrote: > Respected Master of Excel & friends > > I am having

$$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 important

$$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] Pra

$$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