View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vlad Vlad is offline
external usenet poster
 
Posts: 16
Default Macro to input and compare date ranges

I need to allow the user to input a date range €œFrom€-€œTo€ through a form and
the date range should be placed in cells A1and A2 for in QQQ.xls. Then the
macro should compare the date range entered with the dates in column B in
another spreadsheet -ABS.xls and count only the records within that date
range. The result should be in a cell K1 in QQQ.xls for example.

Any help will be appreciated

Thanks
Vlad