Hi!

I want to get data from another excel file. let's name it EXCEL_MAIN and EXCEL_DATA. From EXCEL_MAIN when i type a particular data in a cell A1. I want to reflect the description of that data into the EXCEL_MAIN which the data are all in the EXCEL_DATA. somebody can help me regarding this matter using VBA. thanks

in addtion, on the EXCEL_MAIN I'm going to specify the file name and path of the EXCEL_DATA.

Marky