help with if and looping

[uniks]

hi everyone
hi
i have two workbook, one is named Database.xlsx and the other is a.xlsm
i want to acces the data in Database.xlsx from a.xlsm with some condition
if the condition meet then the value from data searching will fill cell M13 to M22 in the a.xlsm
here is my code

Please Login or Register  to view this content.

thanks

[davesexcel]

Hi uniks,

It would be easier if you supplied the sample workbooks.

[uniks]

here is my workbook
sorry it took me so long to reply
a.xlsm

[davesexcel]

We need the other workbook as well

[uniks]

here is the other workbooks

Database.xlsx

[davesexcel]

You are referring to sheets in the code that do not exist in the workbook.

[uniks]

yes i have change it but it still didn't work

[davesexcel]

You need to set book1 as workbook, not workbooks

Please Login or Register  to view this content.

[uniks]

i tried,
but it show error : "Compile error : Sub or function not defined"