Macro to input and compare date ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
VBA set thick borders around non empty cells in range 0
Macro for Dates 5
Compare shorter date range against longer date range 2
Macro storing as a date? 11
comparing textbox value with values in named range 2
Macros 2
input the date range for update Pivot table 4

Back
Top