hey all
ive been struggling with this file with writing a formula, and im not well versed with macros so i am hoping someone can pls help me...it will probably take someone a few mins.
i have attached my workbook, i want to a filter or have a macro run on "change event" when user selects from drop down:
cell D9 = user name
cell d11 = dates (Jan 1st, Jan 15th, Jan 22nd....Dec 22nd etc) - those are the billing cycles.
-range BD:BO in "master" sheet contain the dates that match the drop down list in cell D11
my data is in the "master" worksheet.
so when user selects name in D9 and selects date in D11, i want the table in "missed account" to filter by revenue taht is missed aka " - " in the workbook.
in range G6:R6 on the missed account sheet, i reference the columns for the respective months that contain " - "
if someone can pls help, i would really appreciate it ..its been a few days on this sheet now :S
thx u so much!
Bookmarks