View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kathie kathie is offline
external usenet poster
 
Posts: 10
Default sort when using VLOOKUP

My sheet has a VLOOKUP set up to fill in name and Biller when client number
is entered. We use this to post checks daily with amount and invoice number.
I want to run a Macro to sort by Biller, Client number and invoice #. When
I created and ran it, it puts all blank rows first the rows with data. How
can I get it to run only on cells with data, based on values?