pivot data

Hello Excel Friends,<br> <br> I have a user form that currently publishes the data to a database sheet in one row, however, what I need it to do is publish the data vertically instead of horizontally, but I need 2 of the form sources to be replicated in each row.<br> <br> My current user form...

Hi, I have a pivot table like below <tbody> <tbody> 201509 </tbody> <tbody> 201517 </tbody> <tbody> 201527 </tbody> <tbody> 201540 </tbody> <tbody> 201544 </tbody> <tbody> 201546 </tbody> <tbody> 201548 </tbody> <tbody> 201550 </tbody> <tbody>...

Hello, I am trying to create a pivot table from data that I have collected from a group questionnaire, there is 40 questions. Each question has about 5 different answer options. Every time I go to create the table it adds all the answers up to give me a total of people that answer. I already...

Hi everyone, I've been searching to find a way of changing my pivot table data source from Access file to a local excel sheet (of same file). Is that anyhow possible? When I select "Change Data Source" From PivotTable Tools / Options, it only allows me to select the second option, "Use an...

I have a number of worksheets that are used as source data for pivot tables (one per table). Ideally I would like for my vba to add a new sheet for the pivot table and rename it accordingly. Right now the code adds a new sheet based on how many sheets there are. More specifically...

I am creating a pivot table with source sheet as follows: <colgroup><col><col><col><col></colgroup><tbody> Date Entity Amount Status 7/2/2013 ParkingB 0.0 IN 7/3/2013 ParkingB 36,107.6 IN 7/4/2013 ParkingB 0.0 IN 7/4/2013 AppleC 547.8 OUT 7/4/2013 AppleC 0.0 IN 7/5/2013 AppleC...

Hi there, I've created a spreadsheet that consists of 2 pivot tables that drilldown into 2 individual lists of customer reference numbers based on the individual pivot table report filters. Due to the report filters selected some customer references numbers can be duplicated in either pivot...

Keep getting close, just not quite yet. I have the following cross tab table that I would like to convert to a flat file. (pivot table ready) The labels that begin w/ > will not contain data, but will be needed as metric labels for the data below each one. As long as I keep these headings out...

Hey Guys, I'm trying to update a PivotTable with the range selected in the inputbox (from another workbook), but I can't seem to get it to work. I don't know very much VBA and have just been putting pieces together so my code might be totally incoherent. Thanks in advance! Private Sub...

I am curious if there is a way to copy slicer selections to a sheet so that I can remember what selections where made when I used the spreadsheet. I do not want to copy the entire slicer, just the selections made. Thanks in advance. I am using MS Excel 2010.