VBA CODE CREATION
- or -
Post a project like this2061
£200(approx. $251)
- Posted:
- Proposals: 0
- Remote
- #2106840
- PRE-FUNDED
- Awarded
Description
Experience Level: Intermediate
Hi,
I need to generate a VBA code that will perform the following:
Step 1.
User completes Row/Columns AU onward with columns that are required.
The user then populates a numerical value in the corresponding column/row created.
Column BH (Last Column) in this example is a sum column which needs to tell the macro how many times the macro should duplicate the row by. (However the Macro needs to be dynamic to read the last column depending on the growing data columns)
Step 2 - the fun part!
Macro is required to read the last column that tells it how many times to duplicate the row by.
The requirement is for each duplicated row the corresponding column headers needs to be populated in column A for that row based on the numerical corresponding column the user completed.
FYI
Within the attached document, you will notice I have tried to crack the logic required bu failed miserably.
Please let me know some costing for this piece of work.
I need to generate a VBA code that will perform the following:
Step 1.
User completes Row/Columns AU onward with columns that are required.
The user then populates a numerical value in the corresponding column/row created.
Column BH (Last Column) in this example is a sum column which needs to tell the macro how many times the macro should duplicate the row by. (However the Macro needs to be dynamic to read the last column depending on the growing data columns)
Step 2 - the fun part!
Macro is required to read the last column that tells it how many times to duplicate the row by.
The requirement is for each duplicated row the corresponding column headers needs to be populated in column A for that row based on the numerical corresponding column the user completed.
FYI
Within the attached document, you will notice I have tried to crack the logic required bu failed miserably.
Please let me know some costing for this piece of work.
Zack C.
100% (55)Projects Completed
45
Freelancers worked with
8
Projects awarded
78%
Last project
10 Nov 2022
United Kingdom
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