'How do we create Dynamic Tables in Excel based on the input provided in a cell?
I was looking if there was any way to possibly do this in Excel, maybe by using VBA or any other concepts.
The below image shows the input-form, where the user gives the required details about the Company going from 1.1 to 1.5.
Now, I want to generate tables based on the value entered in 1.4 of the input form dynamically. The table structure is shown below.
How can I achieve this task? Any help would be great. I'm open to learn about any concepts that can make this task easier.
Thank you!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|