excel vba autofilter

I need help with some vba for Excel 2010. I have a workbook with two sheets: Detail and Tally. I've attached images of each sheet. Data is entered every day on the Details sheet. Column J is auto populated with the current date when a prodno is entered in column D and the week to which the...

Hello, I am learning VBA and have a large code that formats an Excel spreadsheet. The code works, but I just want to see if there is a better way to write the code of Autofit and Autofilter than what I have below for the sake of learning. I ask, too, b/c I hear some people say to not use Select...

hello, I have table, and on one column I have names. I would like to create macro, that will autofilter the rows by each possible value in a loop. For example, if the names are John, Ruth and Hana, the macro will filter once all John rows, then all Ruth's and finally all Hana's (in the loop I'm...