Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Excel 2010: Adding rows based on value from other cell [Closed]

Report
Posts
1
Registration date
Tuesday February 2, 2016
Status
Member
Last seen
February 2, 2016
 -
Hi,

I see that similar questions have been answered many times but mine is a bit different.

First of all, i would like to say that i am very new to Excel VBA so explaining in detail will be appreciated.

Action done: Value entered in cell F4 = x and hit ENTER
Effect desired: x-1 rows should be added below cell F4

Action done: Value of cell F4 changed to = y and hit ENTER
Effect desired: x-1 rows should be changed to y-1 rows below cell F4

This should happen for all values entered in column F starting from cell F4.

Thanks in advance for helping me.

Thank you!
See more