rumbleface
New Member
I have a sheet that I'm pasting into that has 31 columns. I want to setup an AutoFilter to automatically place all rows in Sheet1!.[A3:AF450], into Sheet2!, based on a qualifying condition met in Sheet1![B1:B450]. The qualifying condition is a date format which displays the "ddd", that will be changed by the user every week based on what will be pasted weekly into Sheet1!. Finally, I want to setup 4 other sheets to do the same exact thing, but will pull and display different qualifying info from Sheet1![B1:B450].
This is a "Template" workbook that will be saved as a "Week_Ending" date weekly and the user will start a new workbook from the template every week.
I'm assuming the code will have to be duplicated, through VB, in every sheet, but with a different prompt for pulling the criteria out.
I'm not proficient in VB, so please don't get frustrated with me. If I can also lock the created AutoFilter sheets in the same VB code, that'd be great!
__________________________________________________________________
This is a "Template" workbook that will be saved as a "Week_Ending" date weekly and the user will start a new workbook from the template every week.
I'm assuming the code will have to be duplicated, through VB, in every sheet, but with a different prompt for pulling the criteria out.
I'm not proficient in VB, so please don't get frustrated with me. If I can also lock the created AutoFilter sheets in the same VB code, that'd be great!
__________________________________________________________________
Mod edit : thread moved to appropriate forum !