Deleting Multiple lines

  • Thread starter Thread starter Edgar
  • Start date Start date
E

Edgar

Hi

I have a spreadsheet which lists all invoices that are due
to be included in a weeks payment run. Is there anyway i
can set up the spreadsheet to delete multiple lines for
each supplier so all i am left with is a list of all
suppliers i am going to make a payment to that week.

Thanks
 
Two ways spring to mind that could help.

i) Create a Pivot Table - In the Data menu there is a wizard -
Highlight the range where the data is and follow the steps.

On completion you will select the values as the data range suppliers as
Rows and invoice date as column heading. This will sum the totals due
for you.

ii) Another quick way to sort your data is using the autofilter in the
data menu. Highlight the whole range first (including titles) first
then select this option. From the drop-down arrows go to the invoice
date and select the date you want - The table will show all records due
on that date - This won't total them though
 
Select the entire list of suppliers and do Data / Filter / Advanced Filter / Check 'Unique values
only' and 'Copy to another location' - Select another location and hit OK. This will give you a
list of Unique Supplier names.
 
Back
Top