Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Loop through drop down list
Hi,
I'm new to the forum and was wondering if anyone can help me. This is what I'm trying to do... Highlight all cells from a tab, use a drop down list and select a name from the list, then copy that information and paste it into another workbook, then go back to the first workbook and copy the tab name and paste that name into the tab of the new workbook, then save the new workbook as the name from the list and the current date... I'd like to loop through each name in the drop down list and save each name with it's own file using the current date... Does anyone have any idea how to do that? I hope that makes sense.... Range("A1").Select Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Selection.AutoFilter Field:=29, Criteria1:="Barry" Selection.Copy Workbooks.Add ActiveSheet.Paste Windows("test.xls").Activate Sheets("Workables").Select Application.CutCopyMode = False Windows("Book3").Activate Sheets("Sheet1").Select Windows("test.xls").Activate Selection.AutoFilter Field:=29 Range("A1").Select |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
loop a list with the IF formula | Excel Discussion (Misc queries) | |||
Loop through varible list of sheets | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
LOOP - Adddress List -to email | Excel Discussion (Misc queries) | |||
Loop through email address list to send e-mails | Excel Discussion (Misc queries) |