Fix the accounting head

[Sarfraz Khan]

Dear Sir,

Ref to attached sheet, I have one head called Trial Balance Head and another one is P&L Head, I want fix the P&L heading to fix in front of Trial Balance headings using VBA.

I want a result like, as soon as I generate Trial Balance the P&L Headings should come in front of that.

Please advice.

 

[Luke M]

Hi Sarfraz,

Your workbook has very little information in it...where is your inputs going? Where do you want the output?

As a simple test, fastest way is if you have a table somewhere where you are entereing the Trial labels, would be to put a formula in preceding column (let's say Trial is in col B) like this:
=VLOOKUP(B2,VLOOKUP(Sheet1!$A$4:$B$13,2,)

This will retrieve the correct P&L Head label. If you really want that to be a macro, record yourself writing the formula, and then you'll have the basics for the macro.