Search results

Hi Experts, I need to filter a page field in excel 2003 starting few projects with specific word. How, can i filter the projects starting with specific word using vba. Thanks,

Hi Experts, I need to track project on weekly basis.I need to track all the project id's which got approved (status column) from last week and which do not got approved with their Project Lead (column U) with their savings (column BF). Otherwise I have to do vlook all the time from the last...

Hi Luke, I got it. Thanks,

Hi Luke, Seems good,can you tell me exact location where exe file of 2003 excel is saved so taht in can create a shortcut. Thanks,

Hi experts, I have installed 2003 and 10 together in my system.It seems all my files are opening in 2010 excel but how can i use both version as my choice.Also the file is taking long time to open as all are opening in 10 version.Is there any drawback.what can be the consequences of having...

Hi Faseeh, can you please explain me in an attached sheet taking my raw data. always greatful to you Regards,

Hi Dee, same quest here i used it as GETPIVOTDATA("Savings",$A$14,"Beneficiary Sub Profit Center Name","Automotive Asia Pacific","Year",2013,"Groups","Assembly")>'500000' put not coloring anything.let us know Thanks,

Hi Experts, I need your expert views on this.I have a data arranged somewhat like this Region PROJECTSPROJNO Commodities Status Lever APAC 1234 4567 SHOES APPROVED RfQ EMEA 1235 4568 BELT NO APPROVED LCL APAC 1236 4569 PEN IMPLEMENTED RfQ EMEA 1237 4570 PENCIL APPROVED OMP NA 1238 4571...

Hi Hui, You are great,i always look for these advanced concepts from you guys. i think there is no need to define adOpenStatic or adLockOptimistic as its running fine for me now when i corrected oconn with conn. Thanks and Regards,

Im using 2003 so not sure,anyhow you can go to toolbar there on developer option go to macro setings and then you can disbale all macros.then try and share.let me know

Hi, Try this it may work,goto tools-macro-security make it low.

Hi All, Im using the below adodb query to connect to access db but in the last line rsdata.open im getting run time error 3001 and arguments are of wrong type,are out of acceptable range,or are in conflict with one another. can any one help me on this .below is query. Sub DbConnection()...

Thanks Luke :)

Hi Experts, Is there any website where i can find good notes or videos about Excel form and its events on controls. Much appreciated. Thanks,

Hello Experts, Please help me on this i have got this requirement very urgent.I have attached my file on this link.my requirement is explained in this link: http://speedy.sh/f4cVt/requirement.xls and my raw data is in this link: http://speedy.sh/Sstej/AUT-TEBIT-FY11-13.xls...

pls reply on this. Thanks,

Hi Experts, I am attaching my file in this link: http://speedy.sh/XpcGs/Anlage-1-WKZ-Formenbau-Fischer-2.xls what all i want is that if i go to tablelle2 sheet and there in combobox i need to link all vendor names where i need to select any vendor name value which is present in Tabelle1...

Hi Vijay, Its like buck searching for musk in the jungle but musk is itself in his stomach.You can join Chandoo's website to learn and his VBA Classes which is gng on. Thanks,

Hi Faseeh, Answer to your points 1)which table you want to update from which table?- I want to update EMEA Productivity table in tables sheet and that updateion should happen automatically by writing some formula.I want that formula and once that formula is entered the chart should...

Hi Faseeh, thanks, but your formula is working when i put the values manually in tables sheet and the chart is getting updated in EMEA sheet which is good but here what my requirement is that when the values in EMEA region gets updat.ed for example in cell AW4 then the chart should gets...

Hi Fasseh, Thanks for the reply but where should i write your formula (whcih sheet) Regards,

Hi Experts, Iam attaching my file in this link:http://speedy.sh/mWPtk/Scorecard.xls I want that in the tables sheet if i give the cell reference for april month from sheet EMEA range("AW4") for ex. the chart(first chart) in EMEA sheet for net core prod gets updated for April only. so i...

Hi Suresh, I think you cannot do vlook function untill that file is not opened. Thanks,

Thanks, Luke and SirJB7 .I changed the range and now its working. Regards,

Hi Luke, Can you look into my issue.its something urgent for me. Thanks in Advance :)