Correct this code

    Hello Guys.

    I am no coder, but I refer other codes and try to create new things. This is one such code. There are 2 modules in this workbook. One is working and with the help of that I tried to create another code. But I am stuck. Maybe the placement of the lines are not in order or I have not been able to define some particular variable. Can you please check and help me to correct the code and get the result.

    The module Extract B2B is extracting the data from B2B as required and giving me the right result.

    The module Extract B2C is extracting a part of the data from B2C. The formulas to be applied in Extracted B2C row 2, is not working and also I need to resize the data from E2 to L2 and fill down.

    I had posted the same but seems like no one is able to understand my query. I hope someone here is able to understand it.

    Compile error variable not defined

    The workbook is attached with the expected result.

    Code to correct.xlsm

    Correct this code ...

    What else ???

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Quote from Carim

    Correct this code ...

    What else ???

    Have you ever heard of the imperative mood ...???

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Like 1
    Post
    Anatomy of a Good Thread Title
    Thread titles are used in searching the forum, therefore, it is vital they be written to accurately describe your thread content or overall objective using ONLY search friendly key words. That is, your title used as search terms would return relevant results.

    The title must not use non-essential words such as:"Help needed", "Formula problem", "Please help", "urgent", "Code issue", "Need Advice", etc. Such words dilute the title/search results.
    The title should not contain VBA code or formula…
    S O

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Just marked your thread as solved

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Like 1

  • RAJESH SHAH

    Changed the title of the thread from “Correct this code” to “Solved Correct this code”.

  • Carim

    Changed the title of the thread from “Solved Correct this code” to “Correct this code”.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login