• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

copy specific columns with condition

M

MarkTim

New Member
Hii,
I'm new here. I have two worksheets in my Excel file, so i want to select and copy the columns (Part_Number,Name,Version,Level) from sheet1 to sheet2 in same workbook when the (Level) column include cell >1.

Is there any similar VBA code can help to start with ?

Thanks
 
Marc L said:
Hi and welcome on Chandoo !

As you can directly use an Excel feature for achieving your need
without any code just using an advanced filter !
If you really need a code, just activate Macro recorder
and redo the same manual actions : you will get your own free code !

Read also VBA inner help of AdvancedFilter method …

Introduction to Excel Advanced Filters
Extract data using Advanced Filter and VBA
Split an Excel File in to Many using VBA

Many samples to see in threads of this forum …
​
Click to expand...
Thank you so much, i will read the reference.
i have found code that i can copy specific columns but i don't know how to set the condition if you could give me tips about it.
thanks for your effort
 
If you post an example with some dummy data, I'll set you on the right track, if you want it done with code.
 
MarkTim said:
if you could give me tips about it.
Click to expand...
All is yet in provided tutorials and at beginner level …

Anyway a special tip : when manually using an advanced filter
between two worksheets, always start from destination worksheet !
​
 
You must log in or register to reply here.
Back
Top