Wondering whether this can be done.
Have the following data layout
Sht1
[Date] [Doc] [Debit] [Dr AMt] [Credit] [Cr Amt]
[1.1.06] [100] [Debtor] [10] [ Sale] [ -10]
[2.2.06] [201] [Debtor] [20] [Sale] [-20]
[1.3.06] [R01] [Bank ] [30 ] [Debtor] [-30]
In Sht2 I do a dropdown list. When I return
Debtor (in dropdown box)
Want it to return in Ledger format
[Date] [Doc ] [Dr Amt] [Cr Amt] [Sub-total]
[1.1.06] [100] [ 10] [ 0 ] [10]
[2.2.06] [201] [20] [ 0 ] [30]
[1.3.06] [R01] [0] [-30 ] [0]
I am inclined that this could be possible through a mix
of indirect iserror match vlookup index.
Thanks
Have the following data layout
Sht1
[Date] [Doc] [Debit] [Dr AMt] [Credit] [Cr Amt]
[1.1.06] [100] [Debtor] [10] [ Sale] [ -10]
[2.2.06] [201] [Debtor] [20] [Sale] [-20]
[1.3.06] [R01] [Bank ] [30 ] [Debtor] [-30]
In Sht2 I do a dropdown list. When I return
Debtor (in dropdown box)
Want it to return in Ledger format
[Date] [Doc ] [Dr Amt] [Cr Amt] [Sub-total]
[1.1.06] [100] [ 10] [ 0 ] [10]
[2.2.06] [201] [20] [ 0 ] [30]
[1.3.06] [R01] [0] [-30 ] [0]
I am inclined that this could be possible through a mix
of indirect iserror match vlookup index.
Thanks