I have 2 x databases that i have copied as a text file and pasted into
two separate worksheets in the one workbook.

The first worksheet of data has come from a new database which lists
all current jobs and quotes for supervisors.

The second worksheet of data has come from the financial database
which list all current jobs and all old jobs.

I wish to produce a search/find which will populate the third
worksheet with only current jobs (not old jobs and not quotes), which
will also bring all of the finacial data listed in the same row of
each successfull match.

The first worksheet contains a row of data segregated accross 4
columns, each row relates to a different job, quote etc.

The second worksheet contains rows of data segregated accross 16
columns, each row relates to a different job.

The first worksheet contains general information whereas the second
worksheet contains financial information.

All the entries within the second worksheet are jobs, as jobs can only
contain financial information.

I wish to run a macro that can search both worksheets and when a match
is found based on the address/suburb column populate a third worksheet
in the same workbook with each row from both worksheet one and two.

Unfortunately the text strings containing the suburb/street definition
have been typed differently.

Column C: (Worksheet one) BOSSLEY PARK, 2 MOREE PL

Column D: (Worksheet two) 2 Moree Pl, Bossley Park, NSW 2176

Firstly do both suburb strings need to be the same, hence the first
part of the macro may look at fixing this?

If anyone has a clue what I am talking about and furthermore knows how
I can acheive this, I would be very grateful if you could assist me to
develop this.

I takes me the best part of 8 x hours to do this manually :(

Yours Sincerely

Alan Bartley
Sydney Australia

Hi Alan,

It would appear worksheet 2 has the better format - yes? If that is the
case I believe you should firstly convert worksheet one to the same format,
adding the suburb and postcode as well so they are identical. Once you do
this you will have two identical recxords to that be matched.

Is that what you want to do and if so can I also recommend you put the
address in 4 columns eg 2 Moree Plave - Bossley Park - NSW - 2176 (it will
help with the matching).

Let me know.

"Alan Bartley" wrote:

I have 2 x databases that i have copied as a text file and pasted into
two separate worksheets in the one workbook.

The first worksheet of data has come from a new database which lists
all current jobs and quotes for supervisors.

The second worksheet of data has come from the financial database
which list all current jobs and all old jobs.

I wish to produce a search/find which will populate the third
worksheet with only current jobs (not old jobs and not quotes), which
will also bring all of the finacial data listed in the same row of
each successfull match.

The first worksheet contains a row of data segregated accross 4
columns, each row relates to a different job, quote etc.

The second worksheet contains rows of data segregated accross 16
columns, each row relates to a different job.

The first worksheet contains general information whereas the second
worksheet contains financial information.

All the entries within the second worksheet are jobs, as jobs can only
contain financial information.

I wish to run a macro that can search both worksheets and when a match
is found based on the address/suburb column populate a third worksheet
in the same workbook with each row from both worksheet one and two.

Unfortunately the text strings containing the suburb/street definition
have been typed differently.

Column C: (Worksheet one) BOSSLEY PARK, 2 MOREE PL

Column D: (Worksheet two) 2 Moree Pl, Bossley Park, NSW 2176

Firstly do both suburb strings need to be the same, hence the first
part of the macro may look at fixing this?

If anyone has a clue what I am talking about and furthermore knows how
I can acheive this, I would be very grateful if you could assist me to
develop this.

I takes me the best part of 8 x hours to do this manually :(

Yours Sincerely

Alan Bartley
Sydney Australia