Thread: Auto copy data rows between sheets depending on date entry
View Single Post
  #3  
Old September 24th, 2009, 04:16 AM posted to microsoft.public.excel.newusers
Max
external usenet poster
  
Posts: 8,574
Default Auto copy data rows between sheets depending on date entry
Refinement, line:
In G2: =IF(TEXT($B2,"mmmm")=G$1,ROW(),"")

should read as:
In G2: =IF($B2="","",IF(TEXT($B2,"mmmm")=G$1,ROW(),""))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---