Search results

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

Hi, Faseeh & Hui Good day.......... Thank u the reply,,, Faseeh, i saw the excel file, u put formula only for container # what i want is if i put vendor in Single PO search B6 and A10 field for Container Number,EAN/UPC,CBL Number,Sales Person,Our Reference & Kewill Job Ref. No. if i put...

Hi can any one help me,,,,,,,,,, Pls find the below link https://dl.dropbox.com/u/97330471/PO%20Search%202.xlsx What i need is if i put vendor that relates to container/BL/etc,,, number the end result i want is PO document no. if that container/BL/etc,,, having multiple PO doc no means that...

Hi SirJB7 thanks for the reply 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...

thank u SirJB7, one more request.......... if i put the vendor in C4 and container no in B8 and the end result what i want is PO# in C8 For eg:- Vendor - 40 Container# - CMAU5273342 Result PO# - 9062568683 https://www.dropbox.com/sh/06odug3wzpgvcsu/M_-rKv6-rZ vendor and container...

hi all, Kindly find the below link , now you can get what i want. https://docs.google.com/spreadsheet/ccc?key=0ArEaSV4ZCBQydERXZmRoN2VGUmEzWUk2UXVTeVJLR0E i want PO#, with the combination or vendor and container # thanks for the reply Hui and Sir JB7

i want the combination of vendor and container, have to get the PO# which related to Vendor and container no.

pls check now dude,,,,,,,,,,,,,,

Hi, one more request. for Eg: Kindly go through this link https://docs.google.com/spreadsheet/ccc?key=0ArEaSV4ZCBQydEdQaUpqZGdudmwtMHd6S1pnSElYR1E in sheet 1 - if i put vendor and container no the result PO# has to display all the related data available in sheet 2 can u help me to put...

HI Hui, Thank u soooooooooooooooooooooooo much. it is very useful to me. thanks a lot dude...........:)

hi, can any one help me to find the data in excel with related multiple data For Eg: MRKU2215275 9060370391 MRKU2215275 9060578644 MRKU2215275 9060580450 MRKU2215275 9063176095 MRKU3367164 9063320918 MRKU3367164 9064117570 MRKU3367164 9061607008 MSKU0686160 9062314657 if i...