copy column A from one workbook to another workbook

[mlbs]

Hi, I am trying to copy column A from one workbook to another.

Reason, I have created an inventory workbook to automate most of task but receiving is entered in a seperate workbook, so i need to pull that data which is a list of serial # to my inventory book so i can auto calculate my inventory.

So to copy colimn A from po workbook to my inventory workbook this is the formula i have

=IF(ISNUMBER(MATCH('[po disk.xlsx]Sheet1'!$A:$A,1)),INDEX(july!$D$2:$D$10,MATCH('[po disk.xlsx]Sheet1'!$A$1:$A$10,1)),"")

This is not working can any one help me on this or point me in the correct direction.

thanks in advance
mlbs

 

[JMonty]

Would you rather have a macro do this for you? Sounds simple enough with a macro. If you prefer that one, please post the filepath of the PO workbook.

Hoping to hear from you.

 

[mlbs]

never thought about macro as i have never used them, But i am willing to learn if you can tell me how it works and where macro goes etc.

Thanks again for help.

mlbs

 

[mlbs]

sorry i forgot to post file path to po workbook duh!

S:\production\production shared\myfolder\po disk.xlsx

 

[mlbs]

can anybody help me on this?

Thx
mlbs