Need VBA to automatically copy paste rows based factory selected

[AronNeo]

Currently working on a project and been browsing through the forum last 2 days to find a solution to the problem. I am very new to VBA. thus seeking help for a full VBA code.
I would like to develop a VBA code which copies rows from table sheet1 (source file) based on" Factory" selected in the drop down list in table sheet2 (target file). i have tried array formula to get the results however the data is quite large (around 2000 rows data), therefore either it takes too long to calculate or it stops working.

below are the criteria's.
1) copies rows from source file table based on" Factory" selected in the drop down list in target file table.

2) from the source file table, only require to copy row data from column A till column F. then copy over to target file sheet table

3) there is multiple duplicate data in source file table (from column A to column F). only require to copy the unique data (remove duplicate)

attached file with generic data due to sensitivity.

Thank you in advance.

 

[Alex Blakenburg]

Are you saying you tried the formula below and it was too slow ? That is not what I am experiencing.

=UNIQUE(FILTER('source file'!$A$2:$F$5000,'source file'!$A$2:$A$5000=$C$2,""))

 

[AronNeo]

Hi Alex,

Thank you for the solution it works, however found another issue in regards of the formula shared.

1. column D and Column F can be empty or with different data
2. column F can be empty or have different values

how can i modify the formula to unique filter based on Column A and Column B only however still generating unique list from column A to column F

 

[AronNeo]

RESEND due to incorrect data

Hi Alex,

Thank you for the solution it works, however found another issue in regards of the formula shared.

1. column D and Column E can be empty or with different data
2. column F can be empty or have different values

how can i modify the formula to unique filter based on Column A and Column B only however still generating unique list from column A to column F

 

[Alex Blakenburg]

But if you have different data in C to F for the same A B combination which data do you want to show in C to F

 

[AronNeo]

Hi Alex,

have done the checks, cells in column C to F will either have data (same as other duplicate entry) or blank.

 

[Alex Blakenburg]

Can you show me some sample data preferably as an XL2BB ?

XL2BB
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[AronNeo]

found interim solution which is to update values on duplicate row column C to F based on VLOOKUP in source file prior running the formula in target file to ensure only have unique values in .
however this needs to be done separately every time a data rows is added.

cant seem to be able to install XLBB add ins into my PC, getting msg " this file type is not supported in protected view."
appreciate if i could share the data in other means. Thanks

 

[Alex Blakenburg]

Try right clicking on the Add-In > Select Properties > if in the bottom right corner there is an Ublock check box tick that.
Then try the XL2BB again.

Also when you say the duplicate line is either the same or blank, when its blank are all the cells in C to F on the same row blank ?