Create dynamic dependent dropdown list with dynamic name range in Excel by formulars only
Context What I want to achieve: I need to create an Excel template that enables the team members to submit information. It's a multiple-layer str…
Showing posts with the label DataShow all
Learn VBA by project: VBA calculator for suming up subset by just clicking on the cells
What will we achieve today? Today I have a data set that shows the revenue share of each product category in each region (see below). I want to easil…
Encypted Excel VBA Project with NotePad++
Software needed: 1. Excel 2. Winrar 3. NotePad++ Step: 1. Change ***.xlsm to ***.zip 2. Open ***.zip with Winrar 3. Go to folder "xl" 4. c…
