Hi i want to know if any of you guys have VBA code recommendation for this

i have a cell value in B4 and a table "Store Code"

like this
1.JPG

i want to add rows into another existing tablewith the column "Store Code" with duplicate item number

into this
2.JPG

any help would be much appreciated, thanks!