View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sailmore50 sailmore50 is offline
external usenet poster
 
Posts: 1
Default MOVE DATA INTO UNUSED ROWS

I've set up a database that we use for a call list. One worksheet is the
database & the other worksheet is the call list. Using the If function I have
it set up so when you put an "x" in one of the columns of the database it
moves the data to the call list. But it's moving the data to the same row in
the call list, leaving blank rows. is there anyway I can get the data to fill
in at the next empty row?

Thanks to all