Copy Dynamic Table

Question

All,

I want to copy a table A with dynamic number of rows

But on the table where I want to copy there will be only the three columns - item, description and total.

Is there a way to do that - with or without VBA

Also, if possible , I  am willing to insert a new line - after each date and put a date there. Some-thing like below for the output table

Answer 1

See below,  but the main thing is to have Date as the first row label and then Item and Description

Click in the Pivot and from the menu select Design > Report Layout > Tabular

Then Design > Subtotal > Do not show subtotals

Then in the Pivot Right Click on one of the dates and chose Field Settings > Layout & Print >

Click the check box "Display labels from next field in same column"

Click the check box "Insert blank line after each item label"

Here's a link to a file with the type of layout you are looking for

https://dl.dropboxusercontent.com/u/87775834/Excel%20Community/Pivot%20Layout.xlsx

Answer 2

Excel is capable of some very surprising things

One way to format is to hover your mouse over the top of the first date until you get a black arrow then click - that will highlight all dates and then format.

You can create your own custom designs but it does take trial and error

Answer 3

Thanks.

It really works as intended.

Also excited and amazed on the power of excel - if you know it its really endless the way you can use it, even without VBA.

Only thing is - how do we format an item  Say the description or date to look bold etc

Answer 4

Yes pivot table can sort of give me the table I want 

But how do I get the date as a row item for every row item Is there any workaround on that

Answer 5

Is a PivotTable an Option for you?

If so that's by far the simplest solution