Hi all.

I have a spreadsheet for recording race times and championship points. There is lots of info and quite daunting for some (even with autofilter on and a macro to select the necessary cells).

My thought on how to do this is: (I have a homepage type of thing, a sheet with just buttons etc of what you want to see etc)


A macro that firstly clears all autofilter, hidden cells and sorted fields - Done
On Homepage drop down lists of; what catagory you want to see, what event, how you want it sorted - Done
V lookup for dropdownlists of the correct info (eg what column that would have to hide to see that event) - Done

Hide Cells based on a cell value; eg. Hide = Homepage, D27 value, which says "K:Z,AZ:BA" - Stuck

How can I get the macro to use the value of the cell, which then may change.

After that I would like to then be able to use the cells value in the same way to be able to autofilter and sort based on what someone selects. Obviously I will type the proper data in and have a lookup and use that cell. My problem so far is how to use the cell value.

I have looked about but not seen it used in this way, but it must be possible. Does anybody know please, or know where to point me.

Thanks, KAL46