Re: $$Excel-Macros$$ Need code for Sort & Sub-totals

Hi Please find the sample file attached. Regards Rajender Soni -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN g

Fwd: $$Excel-Macros$$ Help in MS Word macro

Hi Team, Please help me my below problem in MS Word. -- Forwarded message -- From: Nagendra Modupalli Date: Fri, Jul 2, 2010 at 11:14 AM Subject: Fwd: $$Excel-Macros$$ Help in MS Word macro To: excel-macros@googlegroups.com Dear Team, Can you please help me below request.Than

Re: $$Excel-Macros$$ Help Reqired Loop in macros

Hi Venkat, * The purpose of a loop is to get Excel to repeat a piece of code a certain number of times. How many times the code gets repeated can be specified as a fixed number (e.g. do this 10 times), or as a variable (e.g. do this for as many times as there are rows of data). Loops can be cons

Re: $$Excel-Macros$$ How to alter the contents of a row in a sheet

Hi Alex, Please find attached the solution. I have used the following code inside a module Sub village() ' This loop runs until there is nothing in the last cell ' Aindril De (Andy) Do ActiveCell.Value = "[village]" & ActiveCell.Value & "[/village]" ActiveCell.Offset(1, 0).Select

$$Excel-Macros$$ AUTO MAKE WORD FILE

Dear Friends, how to auto generate .doc file using excel data.. in excel sheet cell A1 --> ID NUMBER and B1 --> DETAILS For Example * A1 B1* *ID NUMBER* * DETAILS * 1 012345AMIT KUMA

$$Excel-Macros$$ COMPARING TEXT BETWEEN TO CELL & DIFFERENCE IN THE THIRD CELL

Hello Friends I want to know that can it possible the following idea. Cell A1 contains text >>> Shri Ram Chandra Cell B1 contains text - >>> Shri RAM cHANDRAs I want to that i want the formula in C1 -- which give me the result of that difference between this A1 & B1 the answer is only

$$Excel-Macros$$ How to alter the contents of a row in a sheet

Hi All I was wondering if you could help. I have a column of data which is Column B within a sheet that I wish to alter, the data has the following format : XXX|XXX and I wish to change the contents of the cells in the column from XXX|XXX to [village]XXX|XXX[/village] using a single button

$$Excel-Macros$$ Need code for Sort & Sub-totals

Hi all, Need your help!!! I need a code for sorting & sub-totals for the data which keeps (range) changing every day. Could you please help me in providing the Macro code at the earliest. Thanks for your help in advance! Srinivas --

Re: $$Excel-Macros$$

Hi, I think this formula may be useful for your requirement. =MID(B4,(FIND("-",B4)+1),(LEN(B4)-(FIND("-",B4 Let me know if it works On Tue, Jul 6, 2010 at 4:28 PM, Ankit Chandna wrote: > Dear, > > Can u plz tell me exact procedure.i do hv ASAP utilities. > > --- On *Tue, 6/7/10, Mahesh *

Re: $$Excel-Macros$$

Hi, Please find the attached file for your required solution. Regards Sandeep On Tue, Jul 6, 2010 at 4:28 PM, Ankit Chandna wrote: > Dear, > > Can u plz tell me exact procedure.i do hv ASAP utilities. > > --- On *Tue, 6/7/10, Mahesh * wrote: > > > From: Mahesh > Subject: Re: $$Excel-Macros$$

Re: $$Excel-Macros$$ Fwd:

Hi All, =LEN(A1)+1-FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(TRIM(A1))- > LEN(SUBSTITUTE(A1," ","" The above formula works for me. Thanks a lot for all your efforts in helping me to solve this issue. On Sat, Jul 3, 2010 at 8:44 AM, ju...@thepepeshow.com wrote: > Dave, I think Praveen was

Re: $$Excel-Macros$$

Dear,   Can u plz tell me exact procedure.i do hv ASAP utilities. --- On Tue, 6/7/10, Mahesh wrote: From: Mahesh Subject: Re: $$Excel-Macros$$ To: excel-macros@googlegroups.com Date: Tuesday, 6 July, 2010, 9:50 AM Hi Ankit,   Use ASAP utilities, it will solve your problem.   On Tue, Jul 6

$$Excel-Macros$$ Help Reqired Loop in macros

Dear Group, What you mean by Loop in Macros&Use .can i have explanation with Example Best Regards, * Venkat * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http:/

Re: $$Excel-Macros$$

Hi Ankit, Use ASAP utilities, it will solve your problem. On Tue, Jul 6, 2010 at 1:02 PM, Ankit Chandna wrote: > Hi, > > > hi to all ..i need a help PFA and help me to get reqired result. > > Regards, > Ankit > > -- > > --

Re: $$Excel-Macros$$ Cell Capacity & filters

Hi, save the number as text may help u. On Tue, Jul 6, 2010 at 1:20 PM, Iqbal Muneeb wrote: > Thanks for your reply. That is what I am doing and it is combersome. What > I want to know is as follows > 1.ithere some VBA codes whereby the capacity can be enhanced from 255 > charachters; or Excel

Re: $$Excel-Macros$$ GNATT CHART

Very Good! On Tue, Jul 6, 2010 at 1:19 PM, Intelligent But Crazy wrote: > Hi Zaf > > PFA the gantt chart > > Thanks > SecretShot > > On 7/6/10, zafnu wrote: > > Hi, > > Can u please help me to create a '*Gnatt Chart*' in excel. your immediate > > action is highly appreciated. > > > > Thanks & re

$$Excel-Macros$$ RE: GNATT CHART

Hi, This Gantt chart workbook is excellent! Regards - Dave. > Date: Tue, 6 Jul 2010 13:49:04 +0530 > Subject: Re: $$Excel-Macros$$ GNATT CHART > From: secrets...@gmail.com > To: excel-macros@googlegroups.com > CC: zaf...@gmail.com > > Hi Zaf > > PFA the gantt chart > > Thanks > SecretShot >

$$Excel-Macros$$ Worksheet/workbook events not being triggered

Hi, I have an Excel 2003 spreadsheet pulling in data from a SQL Server database and populating a sheet (called "Data"). I also have a pivot table in a sheet (called "Pivot"). I want to be able to refresh the pivot table when the data import is complete. To work out which event to use as the basis

Re: $$Excel-Macros$$ Hi, need your help - urgent

Good! But instead of copy paste we can use bring to front by keeping all images on same position. On Thu, Jul 1, 2010 at 7:38 PM, ashish koul wrote: > hi > > > Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As > Boolean) > > > If ActiveCell.Row = 2 And ActiveCell.Column =

Re: $$Excel-Macros$$ Fwd:

Very Good! On Sat, Jul 3, 2010 at 2:15 PM, ashish koul wrote: > Thanks a lot Dave. > > > > On Sat, Jul 3, 2010 at 2:22 PM, Dave Bonallack > wrote: > >> Hi, >> A1 = *United States of America* >> >> =FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," >> ","" >> Fir

$$Excel-Macros$$ Merged Cells autofit row height

Dear Experts. I am working on a huge file where some cells have been merged. I need to autofit the row height of the merged cells. A code I have copied from the WEB does not work. Kinldy have a look at it or please suggest a new one. Code is as follows. Regards. Private Sub Worksheet_Change(ByV

Re: $$Excel-Macros$$ Cell Capacity & filters

Thanks for your reply. That is what I am doing and it is combersome. What I want to know is as follows 1.ithere some VBA codes whereby the capacity can be enhanced from 255 charachters; or Excel 2010 would solve this problem ( I have Excel 2007). -- Have a good day! Muneeb Cell: 0300 2213043 -

Re: $$Excel-Macros$$ Problem in list box when using refedit control

it's not working... On Sun, Jul 4, 2010 at 3:03 PM, ayush jain wrote: > Hi Neil, > > As there are multiple items in a range, You need to use FOR EACH statement > to add items of range one by one in listbox. > Attached is the solution for your reference. > > I hope it helps. Please let me know if

$$Excel-Macros$$

Hi, hi to all ..i need a help PFA and help me to get reqired result. Regards, Ankit -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip

Re: $$Excel-Macros$$ Urgent help....

    Thanx Dear --- On Mon, 5/7/10, Deepak Rai wrote: From: Deepak Rai Subject: Re: $$Excel-Macros$$ Urgent help To: excel-macros@googlegroups.com Date: Monday, 5 July, 2010, 2:02 PM Hi Ankit,   Please find the attached solved file. Column highlighted with yello color has the solution