View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
stevieboy1313 stevieboy1313 is offline
external usenet poster
 
Posts: 17
Default Logical test question

I need a formula that says, "Hey, the data entered in cell D6 is =/ 50,000,
so I need to copy all of Row 6 and paste it into another worksheet". Is that
possible? It seems like it would be. But I think that the formula needs to be
in D6, and not in the other worksheet. Would I be better off to record a
macro? And if so, can the IF function be pasted into a macro?