Needinghlp
New Member
- Joined
- Feb 27, 2013
- Messages
- 25
Hello. I’m hoping someone may be able to help with some VBA Code for the following. I have searched for similar queries and while I can find things that I think come close to what I want, they aren't quite right and being a novice I’m not good enough to figure this out myself.
As per the image, I have a list of numbers in column a. They will always be in ascending order and unique numbers, no duplicates.
I then have a cell D1 in which I can enter a number, in this example I've entered 18. This number is a variable field.
There are 2 things I would like to be able to do. The first is the essential part and the 2nd is a nice to have.
As per the image, I have a list of numbers in column a. They will always be in ascending order and unique numbers, no duplicates.
I then have a cell D1 in which I can enter a number, in this example I've entered 18. This number is a variable field.
There are 2 things I would like to be able to do. The first is the essential part and the 2nd is a nice to have.
- When I enter a figure into D1, I would like to be able to click the ‘Insert Row’ button and to automatically find where the value belongs in the list, insert a row in the relevant space and colour that row blue.
- For example, current D1 = 18
- I’d like to be able to click the button and have a blue row inserted between rows 4 & 5.
- The nice to have.. If I updated 18 to 25, I’d like to have that blue row deleted from it’s current position and inserted between rows 5 & 6.