Hello,
I am trying to make a dashboard for one of my collegues which will determine if so called 'LS' and 'FS' deliverables are reviewed and delivered in time. Those deliverables have to be made for about 30 different customers.
I already made the sheet where they fill in the due date and when...
Hi guys,
I've Googled but I haven't been able to find any posts about my problem.
I have imported data directly from a Teradata database and imported it as a "PivotTable Report" and not as "Table". The data is about 300,000 rows which is why I'd prefer not to import this as a "Table" as it...
Could you please tell me VBA coding that I can use to create a dynamic pivot table on a new sheet?
Below is the sample dataset that I want to create pivot table with.
Promotion Name Product Code DC(/Unit)
LG SP-2015Q3-SPIFF-STUDIO-001 LSSG3016ST.BSTESTD 75
LG SP-2015Q3-SPIFF-STUDIO-001...
Hi All,</SPAN>
I have searched high and low, so apologies if this has been asked before.</SPAN>
I am not sure if I am pushing Excel further then what it is cable of</SPAN>
I have a work book with a table that goes from A12 to Z468 that is used for reporting purposes. </SPAN>
My header row...
Basically I’m pulling in data from a DB for this chart. I need to create pivot table chart that has a cumulative sum of various status’ from year to year. The problem I’m running into is that it stops the cumulative sum after 2009 and starts over at 2010. I need it to keep cumulative sum from...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.