Updating second worksheet

[Alex]

In worksheet1, Column B contains the supplier name, Column C their invoice
Number and Column J the Invoice Value. There will be about 1000 in total.
There are many other columns containing other information

On Worksheet2, I need to be able to show the invoice numbers and Value,
listed by row, so that I can group them by supplier. I need worksheet2 to
update automatically if an entry is made on Worksheet1.

Is there a way that this can be done please

Thanks

Alex

 

[Debra Dalgleish]

Instead of maintaining separate sheets, you could keep all the data on
worksheet1, and use filters to display data for a specific supplier. Or,
use a PivotTable to summarize the data by supplier.