Search results

Thanks for the help, it solved now :)

Hi need a formula to check the item status. Item Item status G157970103 generic 4501969498 Normal Missing Missing 4501949034 Normal If the item is blank then missing if starts with G then generic and anything else then normal

Thanks SirJB7 thank you very much Vijay for your time and effort. but my problem is not yet solved. i guess i need to do it manually .

can any one could lookinto my req. pls

Please help me with this .... please see the sample file here. https://docs.google.com/file/d/0B4WaaVJwF8R_WU9LY1ItZHhTbEE/edit?usp=sharing

Hi all I have below macro which i was using previously, now i need to delete the open outlook mail for this and i just need to create the different file in the same location as before. Please help me with this: Sub ExportEmailManual() Dim ObjFile As FileSystemObject Dim x, xDate, z Dim...

I have a excel sheet with more than 100 rows Activities Workday Date Time Send out closing report 18th Tuesday, June 18, 2013 17:00 Track chnages after closing 19th Wednesday, June 19, 2013 17:00 Open new period -5 Monday, June 24, 2013 9:00 Currently I manually change all the dates based...

I have a excel sheet with more than 100 rows Activities Workday Date Time Send out closing report 18th Tuesday, June 18, 2013 17:00 Track changes after closing 19th Wednesday, June 19, 2013 17:00 Currently I manually change all the...

hi all, i have VBA code which uses the outlook to send mails, but now i need it the same for lotus notes. here is my code which i have used in the past. Sub ExportEmailManual() Dim ObjFile As FileSystemObject Dim x, xDate, z Dim xNewFolder Dim olApp As Outlook.Application Dim...

magbo Your formula works very well but i need the table as attached. https://docs.google.com/spreadsheet/ccc?key=0AoWaaVJwF8R_dEdRRlFDeVR5WmlTRTktTlVtcFJIaHc#gid=0 thank you Jagadeesh

Hi all I have simple line chart in which i have data from jan-10 to dec-12 now i need to change the color of the line form future period to red. who can i do this ..? form jan-10 till data the color of the line should be green and form dec-11 to dec-12 should be red. Thank you very much for...

Hi Narayan , Thank you very much it helped me. i want to change font color to red how can i do this ...?

Hello all I have a macro which creates mail with the body of the mail now i want to display month and year in the body of the mail. as October 2011. what is the VBA code for the same..? Currently i am using MonthName(DatePart("m", Date) - 1) which gives me only month name, now i want to get...

Hello srinidhi, Thanks for offering the help, but this is not working when the date mentioned is as 5/9/2011. But it works very well when the date is mentioned 22/09/11. any help with this regard will be much appreciated.. Thanks

Thank you very much Hui, I have tried this but not working for all the dates but works fine only for few cells.

Hi all, I have a data in which the date is showing as below. How can i convert it into the DD-mmmm-yyyy(15-Jan-11)format ..? Please help thanks . 30/08/11 30/08/11 30/08/11 30/08/11 30/08/11 22/09/11 22/09/11 22/09/11 22/09/11 22/09/11 22/08/11 5/9/2011 9/9/2011 25/08/11...

Vijay Thank you very much....it works very well Have a nice weekend

VijaySharma In the entire ranges some of the cells values are more then 0. But I want to hide all the rows and columns whose values are 0. If the cell values are more than 0 it should show the entire row’s or columns or both. Thanks

Hi all I have values in the range B3 :DV54, in this range some of the cells values are 0. Now I want to hide the row & columns if the cell values are 0. How can I do this ..? Please help me Pls find the example: MI PY GC LT 0 0 0 0 0 0 0 0 0 0 0 0 0 0 882 0 0 0 0 0

I am using excel 2007 but i saved the files as 2003 so i was able to get the conditional formatting done. Thank you soooo much and being so kind to me. Thanks again.

Hi Hui I was able to see that something is getting changed but i am not able to access the file its getting struck...not responding properly.. Could you please help again

Hello all I need to compare the material from the file given in the link. I want to compare the Materials mentioned in the column A is available in B ..? is yes Changed the color of that cell. I know that I can’t get the exact matched materials name but at least can I get the relatively a...

Hello Hui please find the link https://docs.google.com/spreadsheet/ccc?key=0AoWaaVJwF8R_dHV2MEtLenRpVFNrWTlzSi1OcGNqaXc&hl=en_US Thanks

Still not able to get the desired solution.. I have company codes mentioned in the column C as 23,37,4A,51,53,54,55,56,79. Can I get the aggregate value for all these co codes for a/c 121000..? I need formula here . When there is only one co code is mentioned I was able to get the values...

I need to get the values in column J to the target data on the basis of given Company code and account number. I was able to get the details where one co code is meniond but I don’t know how retrieve if there are more than one company code. =...