Search results

Hi all, please help me out of this i have created two graphs, and named ranges asdf & qwer surrounding to that, now i want to use asdf & qwer with an drop down list to view graphs accordingly. Thanks in advance

Yipeee.... double bounus for me first my prblem is resolved second solved by chandoo.... good morning chandoo... array is working f9 .....:DD

Thanks Ram, please find the attached sample file with pivot where i want date wise unique count excluding zero. please take care of below points while making pivot 1-exclude zero in report filter 2-date & code in row label 3-pivot in tabular format so that we able to count by function or by...

Hi All, i need a formula to Daywise unique count of code. but if there is any zero it should not be include in count. presently i draw a pivot in tabular format and then i count codes one by one for each date. a sample file is attached. thanks in advance for your assistance.

i too would be happy to do so but its not public its a entprise url (Webpage) from where i need to down load files around 35 files everyday at intervals of 3 hours. thanks in advance

LOL , i am confused asusually..

Hi All My Seniors, I am writing a macro to export excel sheet data from IE8. There are 3 drop down list on that web page. One of the drop down list has only one option in it. say "ALL"(which is second drop down list). When i manually select "ALL" option from same drop down list it refresh the...

Hi All, I am facing a challenge in saving my time as i have to use IE8 to get excel 07 file, Is there any way to create a macro, so that whenever i use shortcut and in result it export the file from a website (on line tool of my company). Many thanks in advance. Regards

Hi Madocar, Did you got answer you are looking for.

Hi Madocar & Hui Sir, sorry for interepting in between please follow the link http://rapidshare.com/files/2530159875/replace.xlsx if it works!!!

Thanks Jeffreyweir, but that's too not working as i am looking for. user will not be able to sort the columns. and yes you are right after filtering and then protecting it working. but still sorting not working. many thanks in advance

thanks Jeffreyweir, please find below link http://rapidshare.com/files/3860241898/Sample%20file.xlsm i also tried to do above method but unable to do. it seems i wrong in selecting check buttons.

Good Morning All Seniors, I am struggling with a new problem from last 2 days that i have a macro enabled workbook. where on sheet1 a userform is made, and data on sheet2 & sheet3 get updated from sheet1 inputs. now i want to protect sheets2 & sheet3 with rights of autofilter & sortin in it...

thanks NARAYANK991 now it is clear for me you have explained it briefly. and now i am clear to use above coding and exlplain to others also. Also declaring hereby that all my concerns has been RESOLVED thanks once again thanks small man & NARAYANK991

Thanks NAYRAYANK991 for RESOLVING this problem after changing my coding with yourones my work is going perfectly. but perhaps i am unable to understand this coding. as per me (i am beginner in vba) application.intersect gives out a common range, in above code we have only one range("$e$3")...

oopss i forgot to unprotect Thanks Narayank991 for replying to my post. and sorry for uploading protecting file here is the new one. http://rapidshare.com/files/447449128/1%20Input%20tester.xlsm thanks in advance

Hi all my seniors, After a long day i have created a macrobased file with these specifications. 1. get data in submission form from data file (just fetch data from 2) 2. update data from submission form to data file (keeps records of latest submission) 3. maintaing records in overall sheets...

OK... I am also laughing on myself after doing above it was really so simple and even i searched on other forums but it was useless. thanks alot Hui Boss...LOLz...hahaha i am really... :)

Hi All, pls help me out of this problem i am preparing a complete Project's health report which will show entire project's report as per the user. for the same i have made some radio buttons but they are not actually doing work as per requirement. please find the below link of my file...

Thanks Marc L your laziness make me learnt two new things ... and fairly as a selfish i would say ""its good to be lazy""... Thanks Shrivallabha coding provided by you is working and also i have did little changes in it. Thanks you both Mr. Shrivallabha and Mr. Marc L my problem is resolved

Thanks Marc L this is working fantastically, msg box is appearing alike i want data in my columns. being as new in vba i am unable to understand some characterstics in coding. your guidance require to make it clear and to use it anywhere for future. 1.FName$ == We declare it as a string...

Hi all my senior, i am confused very much, As related to earlier my post i got a cleaned code from Marc L in my last post which was compiling my 150 files but now tne thing is that compiled files range begins from columnB and end at columnCY What i have ==> 1.Files name format ==&#62...

If you dont have any criteria then you may use below function in cell J2 =IF(E2="","",COUNTA($E$1:E2)-1) or you may also follow below link of macro enabled file with shortcut command Ctrl+Shift+T http://rapidshare.com/files/1718765508/Serial%20Numbers.xlsm

Use this link instead http://rapidshare.com/files/3175553470/EVE%20(1).xlsm regards

Hi DingDang, as i understood you just want to give serial number if there is any value in columnE and itshould not be duplicate & you dont want to skip any number. please share sample file for the same. http://chandoo.org/forums/topic/posting-a-sample-workbook Regards,