Write a code that looks for "True" in a certain column and copy paste to a new sheet

[rangerman50ho]

I'm new to vba and having no luck writing a code to do what I want. I want to copy a whole row to a new sheet if the value in column L is "True".


this is what I have done

Please Login or Register  to view this content.

Book1.xlsm

if I delete all the data from sheet3 and run the macro I get the seven rows that contain true in column L

I believe there is a way to write an "if then" statement to search the whole sheet of 40000 numbers.

I have searched the forums and tried to insert and bend the codes I found here to make this work and I'm honestly lost.
Any help is greatly appreciated.

[protonLeah]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

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, it also maintains VBA formatting.

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



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[rangerman50ho]

My apologies, hopefully these corrections will help everyone, again thank you for your time

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[rangerman50ho]

Thank you, That works on my sample but not on my actual. Any thoughts?
I'm going to try to start a new workbook with the info in it and see what that does.

[JOHN H. DAVIS]

Do you receive and Error? Can't tell why it wouldn't work unless I could see it. I'll wait and see what happens in the new workbook.

[rangerman50ho]

okay, the new sheet it creates is blank, and the on the second tab it hides the rest of the information.

[JOHN H. DAVIS]

Can you post the code you are using?

[rangerman50ho]

Please Login or Register  to view this content.

[JOHN H. DAVIS]

okay, the new sheet it creates is blank, and the on the second tab it hides the rest of the information.

Do you have Header rows? If so what are they.

[rangerman50ho]

yes, the headers are

LINE PART 2014 SALES 2013 SALES PRICE1 PRICE3 PRICE5 PRICE10 CORE DESCRIPTION UPC 1 H>F 1.25 H*M N-F N>F O>10

[JOHN H. DAVIS]

What row are they on?

[rangerman50ho]

They begin on row one.

[JOHN H. DAVIS]

It should work. Try this instead.

Please Login or Register  to view this content.

[rangerman50ho]

That one makes even my sample "new sheet" blank

[JOHN H. DAVIS]

Works for me.