Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The "List " Tab contains a list of 20 Jobs
I want to loop through the "List" Worksheet in every workbook in a folder, copying the list to a "Consolidated" Tab. So if "List" in Wbk1,Wbk2,Wbk3 has 20 Jobs. Then list in "Consolidated" has 60 sub consolidate() set path = "c/My Documents" for each wbk in path wbk.Sheets("List").Range("a1:a20") copy paste: Workbooks("Consol").WorkSheets("ConList") End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Looping through 2 workbooks | Excel Discussion (Misc queries) | |||
Excel VBA - Help looping through all but 2 workbooks | Excel Programming | |||
Looping through all workbooks | Excel Programming | |||
Looping through all workbooks | Excel Programming | |||
Looping through all workbooks | Excel Programming |