V Look Up Table Range

[keiljohnsilver]

Hi

I have a 4 column data table:

Description Code Debit Credit

I would like another sheet to pickup the data in a specific range of codes, with the excel cell layout:

Description Code Debit Credit

Lets say codes 1 to 100 in one batch

then 101 to 300 in another and so on and populate description codes and values (debits and creditors)

Hope this makes sense

 

[SpillerBD]

You could use Advanced Filter.
PivotTable could be a possibility depending on your data and desired detail.