Hi all, this is my first post, hope I've put it in the right area of the forum. First of all, I'd just like to say that I am a complete dunce where VBA is concerned. This task is my first real attempt at using excel in about 5 years and I have forgotten anything I thought I ever knew. (Basically, I found myself feeling quite smug that I remembered how to do a vlookup )
OK - so what I'm trying to do is create an automated advanced filter for the attached workbook, placing the filtered data onto new sheets. I need the macro to create 8 new sheets in total, one for each of the areas listed in column F (if the area is "All", I need the data in that row to appear on all of the 8 sheets). I need the process to be automated because the source data on the Master Timetable sheet will be updated/amended regularly. The idea is to click a button and it will be possible to see what work is required for each Area (if there is an easier way of doing this, please let me know , as I said I'm a dunce).
I tried amending the code that I found here: http://www.contextures.com/AdvFilterRepFiltered.zip spent ages on it, but had issues with ranges etc. and completely failed to get it to work. As I said, I am basically clueless - would be grateful for any help at all whatsoever. May need it to be spelled out very slowly and clearly, though
Bookmarks