• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Make duplicate lines if "B" Column Cell Values have more than one Comp Value, then Update Comp as per Records by line

Gunasekaran

Member
I am a newbie to VBA. I need to create multiple same line based on If The Condition of **“B”** column has Cell-Value more than one Company Values.

Insert one row below the active row, and paste the values of the recently copied cells into the new blank row. Then Update Comp Values by row.

I will appreciate being taught how to only copy certain cells of active rows to paste below. is it Doable in VBA Macro??? - Thank you.

Column "B" Value in below Format

1. PCBA_ISRAEL_400

2. PCBA_ISRAEL_400 PCBA_ISRAEL_400;#PCBA_ISRAEL_T_400

3. PCBA_ISRAEL_T_400

4. PCBA_ISRAEL_400;#PCBA_ISRAEL_T_400;#ISR_CORP_SERV_400;#DSN_ISRAEL_400

5. PCBA_ISRAEL_400;#PCBA_ISRAEL_T_400;#ISR_CORP_SERV_400;#DSN_ISRAEL_400

6. PCBA_ISRAEL_400
 

Attachments

  • Multiple Line create.PNG
    Multiple Line create.PNG
    64 KB · Views: 1
  • Community - if Multiple Cell Value.xlsx
    11.4 KB · Views: 1
Gunasekaran
Please use terms, which can see from Your sample file.
B-column has MEP Codes. Some MEP Codes seems to be longer than others.
What are Your named Company Values?
Could You show Your expected results eg to other sheet?
Many things could be doable after clear details.
 
Gunasekaran
Please use terms, which can see from Your sample file.
B-column has MEP Codes. Some MEP Codes seems to be longer than others.
What are Your named Company Values?
Could You show Your expected results eg to other sheet?
Many things could be doable after clear details.
HI sir, herewith attached Updated Excel file for your reference. I need one line wise for MEP Code, if its multiple MEP Code. Based on count make as duplicate lines and Update MEP code as per count.

If any question. please let me know sir,
 

Attachments

  • Community - if Multiple Cell Value.xlsx
    12.7 KB · Views: 1
The way you teach and code really impresses me, sir. I would like to learn how to code from you. At the moment, I am working on a same loop project.

It's on my to-do list. However, I am stuck in the loop condition (ERP File vs User Report) of validating each file one by one around 89 ERP Files and 89 User Report Files.


I pray to God that this task will be completed within the deadline
 
Back
Top