Hi,
I require a formula that will help me populate T account headings.
I have a data sheet which has a number of GL codes in column G. What I would like is a formula on the “GL Accounts” sheet to self populate unique codes (similar to an advanced lookup with unique fields only).
Then – the main part if the above can not be done (I call always do the filter) is once the list is established on the “GL Accounts” tab I would require the T account headings to self populate.
e.g. The first 2 account looks for the first GL account, then the 2nd T account looks for the 2nd and so on and so on
The fomrula would need to go in the red highlighted cells
Can anyone help please?
Bookmarks