VAB Help - Check Raw Data against MasterDatabase

[rxk]

Hi Experts,

I have to Excel workbooks attached, DBMaster_Partno.xlsx & Raw_MTO_RevA.xlsx. Currently, using formulas like concatenate and match to check datas on Raw_MTO_RevA is consistent with DBMaster_Partno.

I need help to create a VBA to check the consistency of the datas against the DBMaster_PartNo.
Vba steps:

1. start by browsing the Master Database excel files, example: DBMaster_Partno.xlsx
2. browsing raw data excel file to check, example: Raw_MTO_RevA.xlsx
3. run the checking process (match)
4. highlight row with inconsistent values.

Thank you for taking time to help.

Cheers.

[Richard Buttrey]

Hi,

You've done all the work and identified the non matching items. Why do you need VBA

Is this something you need to repeat?

If you do need a macro I'd simply write one that added the formula and conditional formatting you already have.

[rxk]

Hi Richard,

Yes, It is repetitive task and much larger data to process in actual work.
This is one of the steps for the whole process of Material Management Process.

Thank you.

[mogul]

First, Excel isn't really a good database solution. It is very easy to corrupt the workbook. I would switch to a real database like Access or SQL Server. There is a free version called SQL Server Express. It is very easy to do checking as you enter data. You can easily query database for inconsistencies. You can you Excel as front-end for entering data and doing reports.

If you insist on using Excel I would look using Excel as an SQL Database. Google/Bing using adodb to query worksheet.