$$Excel-Macros$$ Re: URGENT HELP

2009-08-02 Thread venkatesh srinivas
sorry guys.. looks like i am too late...to reply sorry ... On 8/3/09, Rajesh Janardanan wrote: > > Guys, > > I am waiting for an answer , Please respond > > Best regards > rajesh > > > On Mon, Aug 3, 2009 at 8:01 AM, Rajesh Janardanan wrote: > >> >> Dear All, >> Need an urgent help , please ref

$$Excel-Macros$$ Re: URGENT HELP

2009-08-02 Thread venkatesh srinivas
rajesh can you confirm if the number of rows in just 13 or will it cross more than that... if its just Jan to Dec.. we can fix it with an simple {if condition.. } or else we need to find other ideas.. Regards Venkatesh On 8/3/09, Rajesh Janardanan wrote: > > > Dear All, > Need an urgent hel

$$Excel-Macros$$ Re: URGENT HELP

2009-08-02 Thread Rajesh Janardanan
Guys, I am waiting for an answer , Please respond Best regards rajesh On Mon, Aug 3, 2009 at 8:01 AM, Rajesh Janardanan wrote: > > Dear All, > Need an urgent help , please refer the attached file , I need a formula > which will read YTD (B13) as the last cell entered , in the attached file > B9

$$Excel-Macros$$ Re: Code not runnig after the file is opened

2009-08-02 Thread vivek agrawal
hi friends Finally i understood the problem and i am sure not many of us know about this... when ever you use the open command to open a workbook, at times it happens that the workbook opens but the rest of the commands do not work... this is because of the SHIFT_KEY press it usually happens

$$Excel-Macros$$ Re: Can any one resolve this?????

2009-08-02 Thread Anurag Kumar
u can do it through vlookup function see the attached file for example On Mon, Aug 3, 2009 at 9:26 AM, Fabio Lemos wrote: > see the attached file... > > 2009/7/27 hemant shah > >> Hi All, >> >> I have recently join the group and i have one query on excel. >> >> Please see the attached file

$$Excel-Macros$$ Re: Transfering values out of a Listbox into a range

2009-08-02 Thread msakibkhan
Dear Jake ! try the following solution: Private Sub cmdOK_Click() Sheet2.Range("A4:A1000").ClearContents For x = 0 To ListBox2.ListCount - 1 Sheet2.Range("A" & x + 4).Value = ListBox2.List(x) Next End Sub Best Regards --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ URGENT HELP

2009-08-02 Thread Rajesh Janardanan
Dear All, Need an urgent help , please refer the attached file , I need a formula which will read YTD (B13) as the last cell entered , in the attached file B9. If I update the file for september B13 automatically should pick from B10. Please advise Best regards Rajesh --~--~-~--~~---

$$Excel-Macros$$ Re: Can any one resolve this?????

2009-08-02 Thread Fabio Lemos
see the attached file... 2009/7/27 hemant shah > Hi All, > > I have recently join the group and i have one query on excel. > > Please see the attached file for the query. > > Hope i will get the response from this group. > > > > Regards, > Hemant Shah > > > > -- Fabio Lemos e-mail: flnle...

$$Excel-Macros$$ Re: help with formula for report

2009-08-02 Thread harris a
Hello Swapnil, Thank you. How do I copy the macro into by work file? can anybody else help me with excel formula. thank you regards Harris On Jul 31, 9:00 pm, Swapnil Palande wrote: > Hi Harris, > > It may be possible to do this using formula. But I don't know how to do it > using formula. >

$$Excel-Macros$$ Re: need help friends!!!!!

2009-08-02 Thread DebApriYA BiswAS
I want only the data of April On Sun, Aug 2, 2009 at 12:12 PM, Daniel wrote: > Hello. > > > > Can you precise, please, if you enter “Apr” in the drop down list, you want > to cumulate “from January to Apr” or “Apr only” ? > > > > Regards. > > > > Daniel > > > > *From:* excel-macros@googlegr

$$Excel-Macros$$ Re: WARNING : Dont change the subject line of any Topic

2009-08-02 Thread TAlgo
Ayush, Thanks and appreciate your help in this matter. Just was little frustrating to search and find out that your topic was completely changed by someone. thx again, On Aug 2, 2:02 am, Ayush Jain wrote: > Dear members, > > We have received concerns from few posters that there subject line

$$Excel-Macros$$ Re: Outlook

2009-08-02 Thread mahesh parab
Hi Sahil below mention link will help you. http://www.rondebruin.nl/sendmail.htm On 8/2/09, Sahil Thakkar wrote: > > > Hi, I need your help. > > I use to send about 400 emails daily and want outlook to autofill the > subject line whenever I click on reply or forward. (Do not want it for > new

$$Excel-Macros$$ Outlook

2009-08-02 Thread Sahil Thakkar
Hi, I need your help. I use to send about 400 emails daily and want outlook to autofill the subject line whenever I click on reply or forward. (Do not want it for new email) only for reply or forward. Subject line is Completed, MT, current date (mm/dd/yy). Please help. regards Sahil --~--~---

$$Excel-Macros$$ Re: Auto Filter - Custom Auto Filter

2009-08-02 Thread jonell
On Jul 31, 2:28 am, Johnnyboy5 wrote: > HI all > > writing a sheet for people at work who dont know how to use Excel > menus etc. > > Auto Filter already turned on. > > I need help on how to write a macro to select the Custom Auto filter > option in the drop down menu (no 3) in a particular c