Re: Copying the data based on the cells availability and Loop it
Sorry for the late response.
Using the attached file data, I have do the below actions:
1. Filter "Column19" on "AGENTorDRM"
2. Filter "Column8" on "KAX0"
3. Again Filter "Column18" on "0"
4. Then Copy Column H, P, X and copy it to new sheet called "Agent&DRM"
5. Replace “KAX0” to “AAX0”
Do the above steps from KAX0 to KAX9 to gather the data to get the required info. At the end of the loop should have all data for "AGENTorDRM", KAX0 to KAX9 (AAX0 to AAX9 – as we are renaming it) and indicator “0”
In my first message, I tried the little coding part for this scenario. Please help me to get the coding for the above scenario using looping.
Please let me know if you require any additional information on this scenario.