Several IF statements that should be And statements

I am trying to write a code to copy information from one worksheet to another that has IF Statements because of criteria that needs to be met in certain cells. But for some reason, it's not picking up the 2nd IF statement. It's giving me every type. Here is the code.

Please Login or Register  to view this content.

I've read about CASE statements, but I'm confused on that part. What is so weird, is that this was working, but then I changed the cell locations so now it's not picking it up correctly. Any help would be appreciated.
Thank you.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Don't use GoTo. Ever.

I can't figure out what you want your code to do, because your code will always execute this line

Please Login or Register  to view this content.

regardless of the If condition. If the condition is True, it goes to this statement. If it's False, it ends up there anyway.

Also you do not have to Activate and Select objects to operate on them.

My best guess is this. If it does not work please attach your file for testing.

Please Login or Register  to view this content.

This code gives me a type mismatch on the If statement. Would that be because the format in those cells in the IF statements are not all text? For instance the value in Cell 53 is a number.
I have attached a sample file.

Cell BA36 has a #VALUE error. That is because the formula is using DAYS, and that function is referencing cells that have "N/A" (text). DAYS gives an error if it is expecting dates but gets text. Then when the code refers to that cell it raises an error.

My suggestion would be to fix your formula so that it does not produce an error. Maybe something like

Formula:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

vanfel can you clarify the data layout you want on the pasted sheet?

Originally Posted by AB33

Please Login or Register  to view this content.

This will certainly paste the desired cells, but they will be pasted contiguously, not according to the source layout. That is, data from C:F will be pasted into A:D, data from P:R will be pasted into E:G, and data from T:W will be pasted into H:K, AD will be pasted to L. Your sample file does not have column headers on the Buyer to Issued sheet so it's hard to tell what you are expecting.