Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

Thanks Vicky. Works like a charm On Saturday, April 5, 2014 3:45:49 AM UTC+4, Vicky wrote: Rashid Sir, I have made some changes. Now you can change your input column to any column in the sheet and output will be 3 column forward and 1 row down from the input data.. If you require data in

$$Excel-Macros$$ Help to merge text from difference cell

Dear experts, I want merge cell containing text value and want comma(,) between all cell value in cocatenate function but my query is that when cell value is blank, the comma should not be display. Is it possible, kindly guide regarding this. Thanks regards. Ashish Bhalara 9624111822 P*Please

Re: $$Excel-Macros$$ Compare two worksheet Trial Balance

Dear Excel gurus, Kindly check the trailing mail. Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -Original Message- From: Sandeep Kumar Chhajer chhajersand...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 5 Apr 2014 04:21:56

Re: $$Excel-Macros$$ Help to merge text from difference cell

please share a sample workbook On Sat, Apr 5, 2014 at 1:18 PM, Ashish Bhalara ashishbhalar...@gmail.comwrote: Dear experts, I want merge cell containing text value and want comma(,) between all cell value in cocatenate function but my query is that when cell value is blank, the comma

Re: $$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

Sub propercase() Dim cl As Range For Each cl In Selection.Cells If cl.HasFormula = False And Not IsEmpty(cl) And Not IsDate(cl) Then cl = StrConv(cl.Text, vbProperCase) End If Next End Sub Sub uppercase() Dim cl As Range For Each cl In

Re: $$Excel-Macros$$ Compare two worksheet Trial Balance

please share a sample workbook with some dummy data On Sat, Apr 5, 2014 at 8:02 PM, Sandeep Kumar Chhajer chhajersand...@gmail.com wrote: Dear Excel gurus, Kindly check the trailing mail. Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone

Re: $$Excel-Macros$$ Delete button on Sequence Column

who will be creating the pattern column ? On Sat, Apr 5, 2014 at 10:30 AM, Falina Gan falina...@gmail.com wrote: To Whom It May Concern, Could you guide me with VBA codes, on these steps:- 1) Create a sequence column as image below ( all in alphabets ) 2) Delete button to delete the

Re: $$Excel-Macros$$ Macro for copying from a notepad and creating a record in excel

can u share how your output look likes On Thu, Apr 3, 2014 at 10:25 PM, Subhra Sardar dkbos...@gmail.com wrote: I am new to VBA and I need a little help with VBA.The file is attached. As you can see below *column B *(EVENT TYPE) there is a field named *JOB* and below the field *JOB* there

$$Excel-Macros$$ Re: How to define the uppercase, lowercase and proper()

Hi Ashish, Good day, I have tested your codes but the texts are not changes at all. The macro have asked me which one to run and I have run all the sub function but still can't see the results. Thanks

Re: $$Excel-Macros$$ Re: Need help for repetative formatting - Repair my code

Hi Suyog Kulkarni, See how build an Excel Add -In http://www.fontstuff.com/vba/vbatut03.htm Regards, Basole 2014-04-05 1:22 GMT-03:00 Suyog Kulkarni nashi...@gmail.com: Hi Basole, It's working fine now following are the only problems remaining. 1. While creating macro, I have assigned