Create a table from a bigger table automatically

[tanmayvg]

Hi,
I am new to this forum. I want to know if there is a macro or any method available to create a small table with required rows and columns and formatting from a bigger table which will be a superset of the smaller table automatically.
For example,
I have a table with data as follows
A B C D E
a1 b1 c1 d1 e1
a2 b2 c2 d2 e2
a3 b3 c3 d3 e3

Now I want a table only with the following data (Columns) with a fixed formatting as below
Title
A B D
a1 b1 d1
a2 b2 d2
a3 b3 d3
Title should have a dark box border, the capital letters should have a double border and the small letters should have a single thin line border.. Currently I need to do this manually with each set of data i.e. applying borders, adjusting row heights for font size etc. is it possible to automate this?

 

[Smitty]

Welcome to the Board!

Have you tried a PivotTable?

It's perfect for what you need. As you add or remove data from your data set, you just refresh the PivotTable to update it. No automation required.

HTH