i have a workbook with 150 different locations, these locations are in a dropdown list. as you select locations the table below changes showing the wages etc (works using lookups)
i need a macro that will
- move through the workbooks 1-150 and save them in set location
- MUST disallow dropdown in C2 after saving - wages etc are shown in the table once the location is selected .
currently these are all on 1 workbook.
need 150 workbooks