VB code to populate (count) data from vertical alignment to a sheet with existing data

Hi everyone,

Could anyone provide a VB code that populates the input data to a sheet with existing data that align with the following requirements?

For example,

• For row 2 of the input sheet, we have a record for the reference code '123.456.789.001' with implemented product 'CM1'. Then, put 1 in the output sheet if row is '123.456.789.001’ and column is ‘CM1’ as cell B2 (blue shaded).
• For row 14 of the input sheet, we have a record for the reference code ‘123.456.789.003' with implemented product 'CM7'. Then, put 1 in the output sheet if row is '123.456.789.003’ and column is ‘CM7’ as cell H4 (blue shaded).
• The existing data (such as cell B3 and cell J3 – yellow shaded) should still in the output sheet.

The example with input samples, existing output and expected output has been attached in this topic.

Thank you and have a nice day.

N.B. The real data contains more than 40,000 records, but they are sticky confidential.

Try

Please Login or Register  to view this content.

Hi jindon,

Your code is work great to transform input data (tab 'Input') to output.
But, the existing data (such as cell B3 and cell J3 in the tab 'existing output') should also still in our output sheet.

For example (in the expected output sheet):-

The blue shaded data are what from the VB code.
But, I have existing data (yellow shade) that should also added to the output sheet in addition to the blue shaded data.

Got it.

Please Login or Register  to view this content.

Originally Posted by cmokasak

Would it be possible to add this code to a button an excel sheet?