Copy data from one file to another if specific cell match between the files

[Panoos64]

Hi to all of you,
I would like to create a VBA code so that to run through col. “B” file D:\users\Items\DriveD\[Items.xlsx]Sheet1 and where the number match with cell “C4” in file C:\Users\Stock\Desktop\[Invetory.xlsx]Sheet1 should pull (copy) the texts from column “H” and place them in col. “N” in file D:\users\Items\DriveD\[Items.xlsx]Sheet1. Therefore, that the copy should be in a horizontal, by transpose option. Please see below an extract of original data in schedule “1” and the expected result in schedule “2”.Thank you all in advance

Schedule 1
C:\Users\Stock\Desktop\[Invetory.xlsx]Sheet1

D:\users\Items\DriveD\[Items.xlsx]Sheet1

Schedule 2

D:\users\Items\DriveD\[Items.xlsx]Sheet1

 

[Panoos64]

Hi once again! Describing my issue i express it wrong. Just simply require how to pull the data from file C:\Users\Stock\Desktop\[Invetory.xlsx]Sheet1!', col. "H" in to col. "N" but in horizontal style, by transpose option. Apologies for my wrong message. The expected result is below. Thank you all in advance!