View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ruth_J Ruth_J is offline
external usenet poster
 
Posts: 1
Default If A1=dog or A2=cat in wrkbk1 sheet1, then copy row to wrkbk2 shee

Hi,
Help pls... I'm only familiar with very basic functions/formulas in Excel
2003. I need to copy an entire row from one wrkbk/wrksht to another
wrkbk/wrksht based on the criteria in two individual cells in that row. (If
A1=dog or A2=cat in wrkbk1 sheet1, then copy entire row to wrkbk2 sheet1)

The original worksheet data is updated daily. Format, header, columns, etc.
never changes.

Thanks for your help,
Ruth