Need a small vba script with a loop to copy an paste values in a worksheet
- or -
Post a project like this2120
$$
- Posted:
- Proposals: 2
- Remote
- #2029307
- Awarded
Description
Experience Level: Intermediate
steps for the makro:
1. disable calculation in worksheet
2. find value in cells B14:AO14, copy value
3. paste value in first empty cell below row 25 (in the same column)
4. Recalculate worksheet
4. Repeat steps 1 to 4 x-times (value for x is read out form a cell in the .xls.-sheet)
5. enable calculation in worksheet
6. End
1. disable calculation in worksheet
2. find value in cells B14:AO14, copy value
3. paste value in first empty cell below row 25 (in the same column)
4. Recalculate worksheet
4. Repeat steps 1 to 4 x-times (value for x is read out form a cell in the .xls.-sheet)
5. enable calculation in worksheet
6. End
Mathis P.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
1 Jun 2018
Turkey
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies