• 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.

VBA to auto filter data in sheet1 from non continous columns and copy to sheet2

P

pprane

New Member
I have an excel file with tab "436" which contains data. This is a data entry sheet.
I want to filter columns B,C,D,E,G,Q from tab 436 and copy this data to new worksheet.

Data when copied to new worksheet should be unique (filtered) and should copy on any change in either of columns mentioned above.

I am able to write a macro which does this when columns are in sequence or continuous. But when the columns are not continuous or not adjacent to each other macro doesn't work. I don't know how to eliminate action on unwanted columns.

Request to help me write macro to work with specific columns to copy and then count the repetitive data

Data is in sheet1 ---- column B,C,D,E,G,QUnique data is required on sheet2 ----- column C,D,E,F,G,H

Thanks in advance
Regards
 
Welcome to the Forum..!!

I am sure, you are likely to receive precise and quick response should you share a sample file along with the required output
 
Hi Asheesh

Please find attached excel file.

Regards,
Prashant
 

Attachments

  • WCS - Copy (2).xlsm
    938.1 KB · Views: 3
I have an excel file with tab "ENTRY" which contains data, this is a data entry sheet. Data will be filled progressively both column wise and row wise on daily basis.
I want to filter columns B,C,D,E,G,V from tab "ENTRY" and copy this data to new sheet "RT REQD" in columns A,B,C,D,E,F.

Data when is copied from "ENTRY" to "RT REQD" for above mentioned columns should be unique. i.e. the answer what I want to get is as shown in the attached Excel file in tab "RT REQD".

Columns in "ENTRY" are not continuous hence I cannot find a way how to compare required columns and filter.

I am able to write a macro which does this when columns are in sequence or continuous. But when the columns are not continuous or not adjacent to each other macro doesn't work.

Request to help me write macro

Regards,
 

Attachments

  • WCS - Copy (2).xlsm
    938.1 KB · Views: 2
Can do nothing without criteria and what means unique 'cause I see
duplicates in result worksheet !

You can use Excel basics like an advanced filter (can manages duplicates to unique) …

A sample in this thread to copy non adjacent columns
using Index and Evaluate.
As you are able to write a code see also the next codes in the same thread.
​
 
You must log in or register to reply here.
Back
Top