• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Fix the accounting head

S

Sarfraz Khan

Member
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.
 

Attachments

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.
 
You must log in or register to reply here.
Back
Top