Hello everyone! I'm back on the forum since I need to dig into some VBA code (or not) that could help me on the following issue:
I want to create a textbox message where the user needs to give an input (= number of different products or services), then, macro will create/remove rows according this input on sheet1 and sheet2, for 3 different sections (volumes, unit prices & turnover).
Note that in sheet 1: column O is a formula, last year goes to 2025 (column BO). While sheet2: is refering directly to sheet1 (simply = the cell), same structure
The idea is then to avoid to complete manually the information when adding or removing products / service lines.
I hope it's clear, but don't hesitate to ask me for more info..
How can I start with the code?
Thanks a lot!
I want to create a textbox message where the user needs to give an input (= number of different products or services), then, macro will create/remove rows according this input on sheet1 and sheet2, for 3 different sections (volumes, unit prices & turnover).
Note that in sheet 1: column O is a formula, last year goes to 2025 (column BO). While sheet2: is refering directly to sheet1 (simply = the cell), same structure
The idea is then to avoid to complete manually the information when adding or removing products / service lines.
I hope it's clear, but don't hesitate to ask me for more info..
How can I start with the code?
Thanks a lot!