Populate Template using VBA

[kenadams378]

Hi,

I have a range of data i need to split using the header codes co1, co2, co3 & co4.

The debits & credits needs splitting into the respective columns and also add the account data for each header code.

I have attached an example of the data and what the template should look like (this has being done manually.

Thanks in advance

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[AB33]

Another option.

[kenadams378]

Many thanks, i've had to amend some of the ranges in the data, could you reflect this in your example at all?

[AB33]

The output is in sheet3, but you can change this line

With Sheets("Sheet3")

To either new sheet or any other name.

[kenadams378]

Many thanks again, while saving this i came across the proper template as attached, the pivot range will remain the same but the journal range will need to start on line 3.

Thanks in advance

[AB33]

I am assuming the result sheet is journal, so no need to adjust the headings and columns.

[kenadams378]

You are a superstar!!

Much appreciated