loop sheets

Hello - I have a workbook containing data from several years. There are three tabs for each year. I would like to output the tabs for each year to their own workbook. I have already used another macro to sort the tabs into ascending order by year, but I cannot seem to figure out how to loop...

I created the code below that works perfectly, however, I have to copy it 12 times for it to work properly. It copies data from another spreadsheet within tabs named for each month (Jan through Dec). Can someone help me make this into a For loop so I don't have so much duplication and...

Hello people, I need a script that loop through all sheets in a open workbook? if a column first cell (always A1) have value="ordernr" then select the whole column Could someone help me? I wrote this could but doesn't work Sub GetData() Dim s As String Dim Current As Worksheet For...