AgustinGuerrero
New Member
- Joined
- May 8, 2022
- Messages
- 3
- Office Version
- 2016
Hello,
I have the following report that needs to be update each time there is a new client. So, based on the last client added I want to run a Macro that adds a new line (in this case will be after client "4" ) and then copy the values in the line above for columns D and Eand paste on the new line added.
So before running the Macro the picture will be like this:
And after the macro is run this is how it should be, so I can add manually the number, name and surname of the new client.
So I'm very new and only have the beginning that I guess is like this:
Range("a:a").Find("4").Select
Selection.Offset(1, 0).Select
Selection.EntireRow.Insert
Many thanks in advance!!
I have the following report that needs to be update each time there is a new client. So, based on the last client added I want to run a Macro that adds a new line (in this case will be after client "4" ) and then copy the values in the line above for columns D and Eand paste on the new line added.
So before running the Macro the picture will be like this:
And after the macro is run this is how it should be, so I can add manually the number, name and surname of the new client.
So I'm very new and only have the beginning that I guess is like this:
Range("a:a").Find("4").Select
Selection.Offset(1, 0).Select
Selection.EntireRow.Insert
Many thanks in advance!!