Thread
:
Auto copy data rows between sheets depending on date entry
View Single Post
#
3
September 24th, 2009, 04:16 AM posted to microsoft.public.excel.newusers
Max
external usenet poster
Posts: 8,574
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
---
Max
View Public Profile
View message headers
Find all posts by Max
Find all threads started by Max