sharad.sony
11-02-2016, 09:45 PM
I have an excel sheet and cell B2 I declare as integer.
I wish that when I enter in cell b2 as 3, value of cells b3 to d3 change automatically as Item-1, Item-2, Item-3.
And when I enter in cell b2 as 5, value of cells b3 to f3 change automatically as Item-1, Item-2, Item-3, Item-4, Item-5.
Please help.
I wish that when I enter in cell b2 as 3, value of cells b3 to d3 change automatically as Item-1, Item-2, Item-3.
And when I enter in cell b2 as 5, value of cells b3 to f3 change automatically as Item-1, Item-2, Item-3, Item-4, Item-5.
Please help.