$$Excel-Macros$$ Re: problem deleting last cell in a specific row

Hi Dear, Attached herewith the file of solution of your question. In that the solution is in column E. You have to copy Column E & paste special it in Column D. Regards, Lavprasad Kori MIS Executive Hindustan Unilever Limited Mob : 9867931351 On Tue, Feb 24, 2009 at 11:11 PM, Mehdi_21 wrote:

$$Excel-Macros$$ Re: Query

Dear Amit, If U want to send one email to all 10,000 mail id's. Then U have to type a mail in MS - Word using mail merge option. For sending it, it does not require , or ; or anything else. You has to select existing list . then open the excel file. select the sheet & Click on OK. U has to do pre

$$Excel-Macros$$ Re: problem deleting last cell in a specific row

Assuming that your data does not have any empty rows: Sub DeleteWhereExtra() Dim I As Integer For I = 2 To Worksheets("Sheet1").Range("A65535").End(xlUp).Row If Worksheets("Sheet1").Range("A" & I).Value = "extra" Then Worksheets("Sheet1").Range("D" & I).ClearContents

$$Excel-Macros$$ problem deleting last cell in a specific row

hey everyone i'm using a table like this one : A B C D 1 Main | value | value | value 2 Extra | value | value | value 3 Main | value | value | value . . n Extra | value | value | value i want to delete every cell in column "D" only when cell in column "A" contains "Extra" value. help plz reg

$$Excel-Macros$$ Re: Query

The solution suggested by Mr. Johnson is the easiest for a layman. I fail to understand why people make simple things complicated. N.Shivkumar Office : +914027685423 Mobile : +919866533180 Res : +914040035774 Alternate Email : shiv1...@yahoo.com --~--~-~--~~~---~

$$Excel-Macros$$ Re: week update

Hello Saravanan, Its not good idea to use NOW() function as it more specifically used to get time not date and the query is about Date not time. Regards, Sarfaraz Ahmed On Tue, Feb 24, 2009 at 7:16 PM, Saravanan Anna wrote: > Hai, > > Try this > > =NOW()-WEEKDAY(NOW(),1)+2 > > it will help you i

$$Excel-Macros$$ Re: week update

Hai, Try this =NOW()-WEEKDAY(NOW(),1)+2 it will help you i think, Regards Saravanan A R On Sat, Feb 21, 2009 at 8:25 PM, Harmeet Singh wrote: > Hi, > > > Below is the formula- > > > =IF(TEXT(TODAY(),"ddd")="Sun",TODAY()-6,IF(TEXT(TODAY(),"ddd")="Tue",TODAY()-1,IF(TEXT(TODAY(),"ddd")="Wed",TO

$$Excel-Macros$$ Re: Query

Hi Naga, Here is the short cut. pls. see the file attached. regds., Johnson On Tue, Feb 24, 2009 at 6:34 PM, Naga wrote: > Dear Amit, > > The easiest way of sending an email for 1 IDs is doing mail merge using > MS Word. > > On Tue, Feb 24, 2009 at 6:23 PM, amit arora wrote: > >> Dear

$$Excel-Macros$$ Re: HELP REQU

Hai puneet It is possible with bseindia website with vlookup method. send me your sample data i will create the link with bseindia and send back to you. Regards Saravanan A R On Thu, Feb 19, 2009 at 10:59 AM, Puneet Jain wrote: > Dear all > > Not recieved any reply for the first one > > othe

$$Excel-Macros$$ Re: Query

suppose you have email id in A column starting from A2 in B2 type =B2 and in B3 type = B2 & ", " & A3 Then drag it till the cell where you have email addresses. in the last cell you will get emailid1, emailid2 and so on. copy text in last cell and paste in notepad or use copy paste value op

$$Excel-Macros$$ Re: Query

Great solution On Tue, Feb 24, 2009 at 6:34 PM, Naga wrote: > Dear Amit, > > The easiest way of sending an email for 1 IDs is doing mail merge using > MS Word. > > On Tue, Feb 24, 2009 at 6:23 PM, amit arora wrote: > >> Dear All >> >> I have excel file with 10,000 email id in one column. I

$$Excel-Macros$$ Re: Query

--- --- Hi, However, Gmail, Yahoo and Hotmail automatically does this task. So Solution

$$Excel-Macros$$ Re: Query

Dear Amit, The easiest way of sending an email for 1 IDs is doing mail merge using MS Word. On Tue, Feb 24, 2009 at 6:23 PM, amit arora wrote: > Dear All > > I have excel file with 10,000 email id in one column. I want to send mail > to all of these. i have to put , or ; at every email id s

$$Excel-Macros$$ Query

Dear All I have excel file with 10,000 email id in one column. I want to send mail to all of these. i have to put , or ; at every email id so that it could be send to all. How can i do it pl tell help me -. regards -- Amit Arora --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: week update

i think even the formula below will solve your problem. =TODAY()-WEEKDAY(TODAY(),3) Regards, Sarfaraz Do visit me on MS Excel help On Mon, Feb 23, 2009 at 4:25 PM, Dilip Pandey wrote: > Hi Savio, > > Supposing you have the date in cell A1, type the following

$$Excel-Macros$$ Re: Urgent Help need to count values

Dear Ashish, Thank U so much. The marco is working fine in module. But, It don't update automatically. Everytime we will edit it and press enter. But if we have lots of data then it is not possible to edit & press enter everytime. For that we has checked Tools Menu - Options - Calculations - Au

$$Excel-Macros$$ Re: How to generate codes for expired contracts?

You're very welcome. On Feb 23, 3:36 pm, Art wrote: > Chris, > > Thanks a lot. I would've spent weeks (not to say months) to figure > this out. > > Tks again, > Art. > > On Feb 21, 12:11 pm, Chris Spicer wrote: > > > > > Hi Art, > > > Contract codes are always a pain.  The following functions g

$$Excel-Macros$$ Re: Actually, Rename Sheet after making Sheet Visible

Hi April, If you swap this block: For i = 1 To PerfAlt.Value wbBook.Worksheets("PerformanceAlt" & i).Visible = True wbBook.Worksheets("InitialCostAlt" & i).Visible = True Next i for this code: Dim wksPerformance As Worksheet Dim wksInitial As Worksheet For i = 1 To PerfAlt.Value