Search results

Hi Experts, I have high hopes from you to solve this tricky powerbi automation requirement. I have attached the screenshot of how i want the output at the end. I want to keep year 2014 as reference . So if any supplier with some part number in some plant as shown in image has no 2014 rate then...

Dear Team, I'm a member of Chandoo powerpivot and excel school but not sure if i can get privilege support there in asking question or where to ask the question so thought of writing it here. I need to know how many times the price increases in same year,same month,same plant/multiple plants...

Dear Experts, I want to create basically 1 pivot table which can summarize my all KPI's .for example-spend,quality and delivery to be combined in one pivot table.How can we do that,i tried using power pivot and created separate tables for region,month (unique) and linked to the kpi data but...

Dear Experts, I have huge data set containing almost 1 million records and when i try to create pivot table out of it it throws me an error saying cannot complete the task with available resources.How to deal such situations as i want to show both data and pivot out of it. I'm using excel 2013...

In the attached file i need to find the output in status column(I) based on criteria tab. I have tried explaining the logic in column I. Please let me know for any clarification if I'm not clear. Thanks for your support.

Dear Experts, I have a requirement where i have there separate reports where all the dimension fields like region,country,location are common to all reports but only the measured fields changes like delivery on time,savings,No of quality products.I need to join all these 3 tables into 1 pivot...

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 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 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 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()...

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...

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 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 Everyone, I have a task to do where i have a raw data in which i have various Vendor names and my task is to create a list or combo or any dropdown and for one vendor name there are many Tool numbers so I want that when i select any one vendor name it shuld show all the corresponding data...