VBA CODE REQUIRED TO DUPLICATE GROUPED ROWS BASED ON 2 COLUMNS
- or -
Post a project like this1831
£100(approx. $125)
- Posted:
- Proposals: 4
- Remote
- #2359982
- PRE-FUNDED
- Awarded
Description
Experience Level: Intermediate
Hi Experts,
I need a VBA code written that can accomplish the below requirement.
REQUIREMENT 1
> Column L
POS QTY column shows the number of times the data set needs to be duplicated.
> Column Q
ROI column this is the grouped number column which needs to be duplicated.
REQUIREMENT 2
If the user has completed POS QTY and there is no number in column Q, please duplicate the row and to be inserted after the duplicated row based on the POS qty column L.
REQUIREMENT 3
Once the Macro has duplicated the row amend the POS QTY column to 1
I have attached 2 files.
1>Ticket Data file shows the raw output file.
2>Ticket Data Required output shows how the final output needs to look like.
I need a VBA code written that can accomplish the below requirement.
REQUIREMENT 1
> Column L
POS QTY column shows the number of times the data set needs to be duplicated.
> Column Q
ROI column this is the grouped number column which needs to be duplicated.
REQUIREMENT 2
If the user has completed POS QTY and there is no number in column Q, please duplicate the row and to be inserted after the duplicated row based on the POS qty column L.
REQUIREMENT 3
Once the Macro has duplicated the row amend the POS QTY column to 1
I have attached 2 files.
1>Ticket Data file shows the raw output file.
2>Ticket Data Required output shows how the final output needs to look like.
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