pull data from one workbook to another in a running list manner

[AWITCHER]

I have attached the two files I will be working with, and have listed the code I am using below as reference (trying to adapt code) and I am surely lost as to what changes I need to make.

I need the information from columns B, AF, AN, AO, & AW from cal ref.xlsx to go to columns C, D, E,B, & F in payment macro.xlsm respectively.
Currently I have (with code below) where the information will pull when I enter in the POS REF into cell A4 and fill in the row's data. I need it to fill the information into the row where I enter the POS REF in column A.

Please Login or Register  to view this content.

[xladept]

There is no attachment

[AWITCHER]

There is no attachment

Sorry I guess I didn't do something right the first time.

[xladept]

Hi AWITCHER,

Try this event code in your now macro enabled PAYMENT MACRO 1 Sheet1 code:PAYMENT MACRO 1.xlsm

Please Login or Register  to view this content.

[AWITCHER]

Thank you, This is exactly what I need!!

[xladept]

You're welcome!