View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kookie kookie is offline
external usenet poster
 
Posts: 7
Default How do you copy all data in a row only if value in column A is "xy

Hi,

i need help. I'm doing a sales spreadsheet for each salesperson. And i would
like to copy all data from sheet 1 (main sales sheet) to sheet 2 (particular
person) if value on column A is equal to "david". I found the same problem
but link is not available anymore. Can anyone help me please?

You will be very much appreciated.


Thanks,

-kookie