List with data to be sorted into various sheets based on column data

[SteynBS]

So I have a Master Data Sheet with 3 columns, Bin number A, Barcode B, and Qty C. I have 2 additional sheets, Bin 1 and Bin 2. I need the Data in Col B and Col C to be sorted and copied to Bin 1 if the data in Col A is 1 and the data of Col B and C copied to Sheet Bin 2 if the value in Col A is 2. Any way to do this with VBA?

 

[Shesil]

Hi,

Can you try this formula. I am not sure if this is what you are looking for or you need a VBA as solution.

=FILTER(Table1,Table1[Bin]=1,"") (Note: Table1 is the table you have shown above and formula is inserted in A2 of sheet Bin1)

 

[SteynBS]

Hi,

Can you try this formula. I am not sure if this is what you are looking for or you need a VBA as solution.

=FILTER(Table1,Table1[Bin]=1,"") (Note: Table1 is the table you have shown above and formula is inserted in A2 of sheet Bin1)

Hi, Thank you for your reply.

Yes, this formula works. I use the formula in the sheet I want the data. I have noticed that there are duplicate values in Col C. I use the unique formula with the filter formula. Works a charm. Thank you. I would however like to achieve this with a VBA. few photos below as reference.

So my source data is in sheet "Cipher data refresh" in Column B, all the data that is a "1" should be copied to Sheet "Write off Z11" and data with a "2" in Col B should be copied to Sheet "Write off X11" In both instances only the unique data in Col C and D should be copied. (Note if there are Duplicate Data in C the data in D should SUM when copied to the other sheet.

In the Sheets "Write off X11" and "Write off Z11" Col A-C I will get the data from another source.