Thread: Copy certain cells in a row to another sheet, based on certain val
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AM AM is offline
external usenet poster
  
Posts: 41
Default Copy certain cells in a row to another sheet, based on certain val
I have one sheet with Twelve columns X 200 rows of data.
I want to check values in column A and Column J. If column A is (not blank)
and column J has a 1 [numeric value], then I want columns B, C, and D in the
same row copied to another sheet.
Reply With QuoteReply With Quote