Hello Jackson. The post is an old one. I don't remember this post. I assume that I dropped the idea of getting the result as it was giving me some problems. If it had worked, then I would have it with me. So, I must have tried to change the whole process and create a new code.
Posts by RAJESH SHAH
-
-
In column T I am getting a Value error. The result I am expecting is B2C as per the formula. If column P contains B2C it should display B2C. in column T. Again, If column P is blank then it should display B2C in column T.
Sorry, I didn't know you have already corrected the formula. It is perfect.
Thanks rory.
-
Hello formula experts
I am getting a value error in some cells where I am expecting B2C. I need your help to please correct the formula and get the correct result.
-
-
Hello experts
I have this code which runs right till the last line and then stops showing an error run time error 7. I am inserting the formulas in the columns G to K and resize them with column A.
I am getting the error at this line -
CodeSheets("Step2").Range("G2:K2").Formula = FormulasArray ' Write FormulasArray to sheetPlease help me to correct this error and get the result. I would really appreciate it. Thank you in advance.
-
The issue is resolved. Thanks to beyond excel.
-
Run time error 7. Out of memory error to correct
Hello code experts
I have posted this query in the link above forum but I haven't had any response till now.
I am trying to add additional headings to KA and ExtractB2B sheets and get the data below the headings with the help of formulas in a code. I got the headings right but I am not able to print the formulas under the headings and I am getting run time error 7. Can someone please correct the code to avoid the error. I also need your expertise to correct some formulas which are converted into code which are not being accepted.
Both the modules of Get headings is working when run from the VBA editor. The get formulas need to be edited and corrected.Add Headings & Get Formulas.xlsm
Thanks in advance.
-
The code is corrected and solved.
-
Can you please check and help me to correct the code and get the result.
This is a humble request.
-
Help me to correct this code please.
-
huh ? I have shared the expected result sheet.
-
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.
-
Thanks rory. That worked perfect. I got both the columns as expected.
-
Thanks Carim.
The formula is working and giving the result for the first 4959 rows and rest of the rows it is showing 0 in both the columns A and B. Only 50% of the rows are displaying and are correct. The range in the formula too looks right. Can you please check the formula and check whether it works in that workbook.
-
No. My sheet is not protected. I am using excel 2019 but I want the formula to work in old versions also. I am trying to get column B and C records from step3 sheet to Extract B2B in columns A and B. Vlookup doesn't work in the left so using choose function.
-
Hello Formula experts
I am trying to use the choose function to get a match and it is showing me an error0 Can some one please tell me what is wrong with the formula and how to correct it.?
-
It really helped me but I wonder why you wrote sheet9 instead of sheet12. Well, the issue in hand is resolved. Will let you know if I face any other issue.
Thanks once again Carim.
-
Actually. In the step3 sheet, the correct number of rows to display are up to row 34. The rest of the rows are unnecessarily derived how I am not aware. Maybe, in the code, if you select the data in the Step2 sheet from A1 to the end -1 row (Exclude Grand total row), then maybe the issue can be resolved.
-
Carim. I am facing an issue in one of the modules which was shared by you. There are columns filled with unwanted values after column S which have to be blank. Can you please check and help me correct the problem Please? Due to this the step4 to step6 sheets are also showing the same unwanted values. If you will help me correct this in step3 then automatically the other sheets will be corrected.
I will share the file in some time.
-
Seems to me you could Autofilter the rows to be deleted ...and as a consequence keep the ones you need...
the ones where the word Total appears ...
This really helped me. It saved a lot of steps.
