Sneaky Pete
New Member
- Joined
- Jun 3, 2016
- Messages
- 23
Hello all,
I hope you can help me with some VBA code.
This is the problem:
In a sheet I've got the following data:
Column B contains a version (100, 101, 102). Each version can have one or multiple rows.
Column C contains increasing numbers a row (1, 2, 3, 4, etc.).
When the user clicks a button for a new version, the last version has to be found, then, all the rows with the found latest version has to be copied and paste below the last found version and in column B the version has to increase.
In column C the numbers has to increase automatically, like 5, 6, 7, etc.
The previous versie has te group automatically.
I managed to do this, but it's a lot of following code, and it sometimes gives an error. Anyone who can help?
Thanks in advanced.
Sneaky Pete
I hope you can help me with some VBA code.
This is the problem:
In a sheet I've got the following data:
Column B contains a version (100, 101, 102). Each version can have one or multiple rows.
Column C contains increasing numbers a row (1, 2, 3, 4, etc.).
When the user clicks a button for a new version, the last version has to be found, then, all the rows with the found latest version has to be copied and paste below the last found version and in column B the version has to increase.
In column C the numbers has to increase automatically, like 5, 6, 7, etc.
The previous versie has te group automatically.
I managed to do this, but it's a lot of following code, and it sometimes gives an error. Anyone who can help?
Thanks in advanced.
Sneaky Pete
