A
Alan Bartley
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
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