Code to create a sheet and get selected data from the source sheet

Hello code experts
I had posted this query in this forum but I have not received a single reply.
https://www.mrexcel.com/board/thread...sheet.1218091/
There is only one sheet in the workbook B2B with Code button sheet. The Not imported is the expected result of the code which is to be created. When I press the button, a new sheet is created "Portal". I need your help to get the "Not Imported" sheet with the help of a code. The "Not Imported" sheet which is manually created to show the expected result. I should be able to get the result with a single button with both the sheets created. I have a rough idea how to write the code but as I am not a coder I can explain my requirement.
Create a copy of Portal In the Random Access Memory and with the help of below steps create the Not imported sheet. As some of the rows are combined in the portal sheet by the code, copy the rows from B2B to Not imported. The Portal sheet is only for reference to get the 0 Rates and rows with Yes / Y in column H.
1. In the portal sheet, If the value of CGST, SGST and IGST are 0 (Match Entire cell contents), then shift those rows to "Not Imported" sheet row 7 onwards as displayed in B2B. Please note: not from portal but from B2B
2. In some rows where the value of Invoice Value and Taxable are same shift those rows to "Not Imported" sheet as displayed in B2B. Please note: not from portal but from B2B
3. Shift the rows with Yes and Y in column H to "Not Imported" sheet as displayed in B2B. Please note: not from portal but from B2B.

This new project is created with the help of comments of previous applications. I would really appreaciate if comments are written at the end of each line of code. It will really help me to edit and create future applications.
Thanking you in advance.

Taxes columns are K L M and N only
F is the invoice value as mentioned and J is the taxable value
You are right. Column H is to identify Yes / Y which are to be shifted to Not Imported sheet.
Also column I is 0 (match entire cell contents) then shift those to Not imported sheet.
Where the values in column F and J are the same in a row then shift them too to Not imported sheet.

Logit, are you still trying to create the new sheet and get the required data.? If you think this is tough then you should see the next query i am going to post. I am not sure whether it is possible or not.

Please Login or Register  to view this content.

You had a recent post regrding creating a new sheet and adding headings so you should be able to incorporate this into your current code.

You "corrupt" yiour data by adding"-Total" to Invoice Numbers in Portal so they NEVER match those in B2B: not very smart!!!

Sorry ... but I cleared the data while tesitng.

Change the Ortal extract.

To add The -total in the portal sheet s a necessity, but that column is no where connected in the above 3 conditions. I hope you are not confused with invoice value to Invoice number..
Please note: In the expected sheet, there is no -Total as the data is copied from the B2B sheet. I have entered by mistake in that sheet.

Please Login or Register  to view this content.

I changed macro to check Party No rather than Invoice to select all B2B records to be included.

And why are you re-creating the "Not Imported" sheet: if headings change (?!!) then simply clear "Not Included" then copy headings from "B2B" to "Not Included".

Similar for other sheets.

Sorry I didn't replace the old with the new code. It is working but it is not showing the last 2 rows where Invoice value and Taxable value are the same. (condition 2).

John Topley. I have re constructed the whole idea to get the data from B2B to 2A and Not imported sheets. I have tried to make it as simple as possible for you to understand. I hope it would be very easy for you to write the code once you have understood it.
In the workbook there are 3 worksheets only B2B, 2A and Not imported. After I open the workbook, I have to paste the new B2B data in the B2B worksheet. The 2A and Not imported sheet will be blank when opened. I have explained the details in brief how I manually separate the B2B data and get the data in the 2A and Not imported sheet. The code in the workbook is of a previous query which I was not able to edit. Maybe it will help you to understand better.
The other 2 sheets in the workbook are to show how the expected result will be.
Please have a peek at this and if possible include the code for conditional formatting of B2B within the code.
Thank you in advance.

Please Login or Register  to view this content.

This is just perfect man. Phew! After 10 days of changing the ideas multiple times, finally we got this right. Thank you very much John Topley. You just solved the most complicated part which was pending since long. Thanks once again. See you soon.
I am not able to add reputation to your latest post. Maybe I can give reputation only once per post.

All the problems are solved but one.

John Topley. Your code is perfect man. It is just that I received a new data yesterday in which some invoice value rows were not matching and having wrong total. (The total of columns J k L and M should be equal to column F with a nominal difference of +1 or -1).
I want your help to add one more condition in the code. Match the amount of Column F with the sum of columns J K L and M and if the difference is more than +1 or -1 then shift those columns to Not imported sheet. In this case the rows 275, 276, 278, 279, 281 and 282 to be shifted to Not Imported as difference is more than 1. The rows with the wrong total can be anywhere in the sheet. This is just a sample sheet and I have entered them in the end of the sheet for your reference.

John Topley, I hope you are reading this. Issue 2. I have one issue in getting the 2A data. The invoice numbers are converted into numbers by the code in some cases where the invoice number is like in the yellow cells in the below image. Can you please edit your code to get the data as text.? Issue 1. in post #31
Attachment 802304
I got the issue 2 corrected. I formatted the column of invoice number as general in the 2A data sheet and I got the correct values.
Only one issue is pending. Not an issue exactly, I wanted to add one more condition with the 3 conditions you have already mentioned in the code.

I am not receiving any replies for this post. Is this post closed ? Can I continue in the same post or should I post a new one ?
I added one line in the code and got the value of the date like invoice number correct but got errors in non text invoice numbers. I hope someone will be able to solve this issue.
Line added in the end of the code as:

Please Login or Register  to view this content.