I’m new to VBA and need some help with copying dynamic ranges from Sheet2 to Sheet1.
In Sheet2, I have 5 dynamic ranges. Named in col."A" as: Dep-1, Dep-2, Dep-3, Dep-4, Dep-5
Each range have data in column A,B,C,D,E and I.
Below range name (e.g Dep-1) are some rows with info. Then...