Automating formula to build summary tables

[Matty5894]

This may be a ludicrous request and not even possible.

I'm recently new to VBA coding and only know the basics, so if statements and looping are well outside of my skill level currently.

But am really impressed with the versatility at what excel can do and I'm using macro's more and more.

Mainly thanks to this site

Attached is an example of the summary tables I do analysis on built from raw data, its always the same process which I'm thinking a macro may possible automate this.

Any advice either way if its possible or not be greatly appreciated.

Cheers
Example.xlsx
Matt

[Speshul]

Assuming this is the desired output, if there is a column with the same value for every row representing that value (for example, if 'Question 1' was in F2:F4, and 'Question 2' in F6:F10) you can use the Subtotal function to get a summary that will look almost exactly like this.

Assuming the above, and assuming the unformatted sheet contains standard headers and a long list below them:
Select all data (entire columns is fine) In the Subtotal menu (Data Tab) select At Each Change in "Question Type/Column F/whatever the semi-constant value is mentioned in the previous paragraph"

Use Function "Sum" on Column B

Would this be something you could use? It's no macro, but it will give you that same output in a few seconds. you could always record yourself setting the Subtotal and use that as a macro anyway

--------------------------

Edit: I didn't read the textbox on the file, so the above may or may not be relevant. It would allow you to add the SUM column C without going through each Question type manually selecting how many rows need to be summed though! :|

[Matty5894]

I've not used this particular function before so not exactly sure what you mean sorry.

Only the text bold in red appear on the top row of a raw data sheet as the various question types.

All the answers for that are found below the header in the column

I need to make a summary sheet as shown in the example document.