One tricky question
I have a two tables - one is a source data and the second one is a new data.
The two have same column headings.
The new data table can have new records or same records same as source data,
but with some changes

For example

Record Table Heading
1 Source Department
1 New Department

I need to update the source data with the new records and update all the
information that has discrepancies in new data
I tried to set up a querry (miscrosoft querry) with no luck.
How to do it?

One tricky question
I have a two tables - one is a source data and the second one is a new
data.
The two have same column headings.
The new data table can have new records or same records same as source data,
but with some changes

For example

Record Table Heading Data
1 Source Department Marketing
1 New Department Finance

I need to update the source data with the new records and update all the
information that has discrepancies in new data
I tried to set up a querry (miscrosoft querry) with no luck.
How to do it?

Sorry, Eva, but it is not very clear what you want. Give a bit more sample
data.
Chip has lots of useful stuff on duplicates at
http://www.cpearson.com/excel/Duplicates.aspx
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


"Eva" wrote in message
...
One tricky question
I have a two tables - one is a source data and the second one is a new
data.
The two have same column headings.
The new data table can have new records or same records same as source
data,
but with some changes

For example

Record Table Heading
1 Source Department
1 New Department

I need to update the source data with the new records and update all the
information that has discrepancies in new data
I tried to set up a querry (miscrosoft querry) with no luck.
How to do it?

I can show you one example
Some of the data in source can change. A new information or the one that
should be changed is in a new table
I marked red the information that has been changed in new and I need to
update it in source data automatically
Source data
Record Deparment HC Total
1 Marketing 2
2 Finance 3
3 Marketing 4

New Data
Record Deparment HC Total
1 Finance 2
2 Finance 5
4 HR 10


"Bernard Liengme" wrote:

Sorry, Eva, but it is not very clear what you want. Give a bit more sample
data.
Chip has lots of useful stuff on duplicates at
http://www.cpearson.com/excel/Duplicates.aspx
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


"Eva" wrote in message
...
One tricky question
I have a two tables - one is a source data and the second one is a new
data.
The two have same column headings.
The new data table can have new records or same records same as source
data,
but with some changes

For example

Record Table Heading
1 Source Department
1 New Department

I need to update the source data with the new records and update all the
information that has discrepancies in new data
I tried to set up a querry (miscrosoft querry) with no luck.
How to do it?

I can show you one example
Some of the data in source can change. A new information or the one that
should be changed is in a new table
I need to update it in source data automaticaly - first record for
department name, the second for HC Total and add a new for record 4:

Source data
Record Deparment HC Total
1 Marketing 2
2 Finance 3
3 Marketing 4

New Data
Record Deparment HC Total
1 Finance 2
2 Finance 5
4 HR 10


"Eva" wrote:

I can show you one example
Some of the data in source can change. A new information or the one that
should be changed is in a new table
I marked red the information that has been changed in new and I need to
update it in source data automatically
Source data
Record Deparment HC Total
1 Marketing 2
2 Finance 3
3 Marketing 4

New Data
Record Deparment HC Total
1 Finance 2
2 Finance 5
4 HR 10


"Bernard Liengme" wrote:

Sorry, Eva, but it is not very clear what you want. Give a bit more sample
data.
Chip has lots of useful stuff on duplicates at
http://www.cpearson.com/excel/Duplicates.aspx
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


"Eva" wrote in message
...
One tricky question
I have a two tables - one is a source data and the second one is a new
data.
The two have same column headings.
The new data table can have new records or same records same as source
data,
but with some changes

For example

Record Table Heading
1 Source Department
1 New Department

I need to update the source data with the new records and update all the
information that has discrepancies in new data
I tried to set up a querry (miscrosoft querry) with no luck.
How to do it?