Recent content by sathis85

Hi All, Can anyone help me for the issue; I need to download some excel files from web link, that files updated on daily bases on the same site. The thing is that I have download through web link and it is my daily process. Pls any one help me is there any possibilities to download...

Hi Friends, i am using MS outlook. Every day i need to open and check mail, in that i want to know is there any macro available for exporting mail to excell sheel every day in single click. can any one pls help me to formulate template for this. Regards, Sathis.

Hi All, Is there any VB code available to refresh an excel file automatically every 10 min.

Hi Hui sir, =IFERROR(INDEX(Table1[Account],ROW(Table1[Account])*(Table1[Salesperson]=$H$2)*(Table1[Region]=$H$3)-1),"") In this formula you have used name manager. pls guide me how to use name manager for the hole table as like you applied in the work book" Table1". Reg, Sathis

Pls find the below link https://dl.dropbox.com/u/97330471/PO%20Search%202.xlsx here i have created PO# search file with more formulas, if i search PO Document Number in this sheet getting the po no very slow,,,,,,,,,, can u pls advice what i did is correct or any changes will help me to...

Hi Hui, Thanks for the reply,,.................. Actually i don't want "Blanks" in my PT and every time i refresh it could not appear also. pls help me to find a right solution Thank u ,,,,,,,,

My source data has empty cells. When I PT this data - the PT shows "(blank)" for the empty cells. How can I keep the cells "empty" in the PT. I do not want to manually filter and uncheck (blank) as this removes other data which is needed. Kindly find the below file...

Hi Jabba1963, one more help My source data has empty cells. When I PT this data - the PT shows "(blank)" for the empty cells. How can I keep the cells "empty" in the PT. I do not want to manually filter and uncheck (blank) as this removes other data which is needed. Kindly find the below...

Hi Jabba1963, thank u soooooooo much dude its working.

Hi all, Can any one help me to consolidating pivot table given below link https://dl.dropbox.com/u/97330471/Pivot%20Table.xlsx i want the consolidated dates in yellow fields. Thanks :)

:(

HI Excel Ninja Good day every one,,,,,,,,,,,,,,, any one pls help me,,,,,,,,,,,,,, :(

HiSirJB7, i made changes as you said in earlier post,,,,,, but i cant able to find the correct formula to place it in right place,,,,,,,,,,,,i don't know how to use formula like INDEX and MATCH could u do me a favor,,,,,,,,, kindly pls change the formula from the file which i have and send...

Hi SirJB7, Thank u soooo much for your valid suggestion

Hi all, kindly go through the below link and pls send me the good solution https://dl.dropbox.com/u/97330471/Multi%20return%20of%20data.xlsm