Thread: Copy Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mas[_6_] Mas[_6_] is offline
external usenet poster
 
Posts: 3
Default Copy Data

Hi All,

I have several worksheets in my workbook.
i want to copy filtered data(if field 4 ="N") from each
sheet based on the sheet name (if the sheet name
contains "02") to last sheet (sheet45)

how can I do this using code?

Thanks
Mas