asked on

Add additional search function

Hi Experts,

I would like to request Experts help to extent of the search data function at Sheet 1 (DataUpdate). The current macro able to trace and displayed all data from Column D (MasterData workbook) based on entered data at cell C2 (DataUpdate).

The search function need to extent also at Column A and E from MasterData workbook. If any data entered in Cell C2 (DataUpdate sheet) and the data available in MasterData workbook (at column A, D oe E), the matched data will be displayed at DataUpdate sheet.

I have attached the workbooks for Experts perusal. Hope Experts will help me to add this additional function.
SearchData2.xls
MasterData.xls

SOLUTION

Saqib Husain

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

ASKER CERTIFIED SOLUTION

apresence

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Cartillo

ASKER

Hi apresence,

Thanks for the code. Is that possible to set the MasterData path, planning to save the workbook in a network folder "\\o3share\data\" and my searchdata will be copied at users desktop.

Set oBook = Workbooks.Open(Me.Parent.Path & "\MasterData.xls")

After copied the data can we closed the MasterData workbook?

SOLUTION

apresence

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Cartillo

ASKER

Hi,

Thanks for the code, what line I need to add if I want to close MasterData workbook after the data has been update into SearchData wb. Please advice.

SOLUTION

apresence

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Cartillo

ASKER

Hi apresence,

Thanks a lot for the superb solution.