nickthebizz
New Member
- Joined
- Jan 24, 2021
- Messages
- 22
- Office Version
- 2016
- Platform
- Windows
Hi I have the following table shown in the image. I am trying to figure out a macro do to so.
I would like to specify the number of rows which this macro should preform once I give the number of rows and press the button.
Example, when i specify 2 rows then I want to delete the data in the last two rows (20 and 21), copy from row 2 until 19 to row 4 until 21. And then clean the data from row 2 and 3 so I can add new data there.
Basically to shift all data from row 2 until 19 two steps down and clean the first two rows for the new data. The last two rows are not needed anymore.
I
I would like to specify the number of rows which this macro should preform once I give the number of rows and press the button.
Example, when i specify 2 rows then I want to delete the data in the last two rows (20 and 21), copy from row 2 until 19 to row 4 until 21. And then clean the data from row 2 and 3 so I can add new data there.
Basically to shift all data from row 2 until 19 two steps down and clean the first two rows for the new data. The last two rows are not needed anymore.
I