View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elton Law[_2_] Elton Law[_2_] is offline
external usenet poster
 
Posts: 173
Default Add Rows depends on the number in a cell

Dear Expert,
In A1, it has a number 3.
In A2, it has a number 5.
In A3, it has a number 4.
I want to run a marco that add 2 rows if A1 contains a number of 3.
It adds 4 rows if A2 contains a number of 5.
It adds 3 rows if A3 contains a number of 4.
After running, Number 3 will move to A3 (add 2 rows already).
Number 5 will move to A8 (add 4 rows already)
Number 4 will move to A12 (add 3 rows already)
Is it too difficult ?
Thanks in advance.