Thread: [Solved] Setting autofilter criteria using columns and cells relative to the active cell in another sheet
View Single Post
 
Old 06-09-2015, 12:44 PM
SarahL SarahL is offline Mac OS X Office for Mac 2011
Novice
  
Join Date: Jun 2015
Posts: 4
SarahL is on a distinguished road
Default
Yes I hard coded some values in the macro auto filter just to test it could be done. Instead of those hard coded values I want to pass through the values from the overhead analysis sheet. If the user clicks on cell C6 for Accounting in April (value = 37) then the sheet should check the month and year from the date in cell C5 by using MONTH(C5) and YEAR(C5) because the value in cell C5 is a date that is formatted to look like a month.
I hope that's clear?
Thanks
Reply With Quote