Setting autofilter criteria using columns and cells relative to the active cell in another sheet

charlesdh · #1 06-08-2015, 10:21 AM

Hi,

Welcome to the forum.

It would help if you attached a file for us to look at.

Note:
I too use Excel for "Mac"

SarahL · #2 06-09-2015, 04:12 AM

Thank you charlesdh,

I have attached a test example. I have set up a command button in the sheet 'Overhead Analysis' which opens the sheet 'TranDetail' and sets some filter criteria but they are just fixed at the moment. I would like them to be set based on the corresponding values relative to the active cell in the Overhead Analysis sheet when the button is pressed.

Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create a New Sheet from Existing Sheet with Specific Columns	malam	Excel Programming	1	10-17-2014 10:01 PM
Matching Criteria against a range when criteria is not in contiguous cells??	GMorris	Excel	9	08-20-2014 02:15 AM
Autofilter on two Date Columns	OTPM	Excel Programming	3	04-29-2014 12:56 AM
From an XL sheet ,how to keep the group of columns which match with other XL sheet	Zubairkhan	Excel	2	03-04-2014 10:57 PM
How to merge two cells from sheet1 to one cell in sheet2 in next sheet	KIM SOLIS	Excel	6	10-30-2011 11:14 PM