how to append the new records at the end of sheet

nsvmani

Board Regular
Joined
Jun 12, 2006
Messages
72
Hi..

I have 2 sheets called Master and Child.
Master sheet contains 3 columns A11:EMPNO,A12:EMPNAME,A13:DESIGNATION. The values are coming under this.

Child sheet also contains 3 columns with the same column names in the same location.

Is it possible to compare those 3 values in the Master sheet with the values in Child sheet??
If the all the 3 values are not matched with each other sheet, then just read those 3 values from Child sheet and append into Master sheet's end of the record.

Regards
venki.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

nsvmani

Board Regular
Joined
Jun 12, 2006
Messages
72
Please provide me the hint or solution to achieve the above problem.
regards
venki
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hi, venki,

your post is not clear to me
it is also confusing
you are talking about columns while your A11, A12, A13 seems to talk about rows :confused:
please explain again and include an example


you might consider to post in another language ... there is a forum "questions in other languages" here

kind regards,
Erik
 

nsvmani

Board Regular
Joined
Jun 12, 2006
Messages
72
Thnks for your response Eric!
Its just includes 3 column names EMPNO, EMPNAME,DESIGNATION.

Under these header columns, values are there in both sheet Master and Child sheets.

I have to compare those 3 values in both sheets,If the values are matching , then take thos evalues from Child sheets and put them in end of Master sheet.

Let me explain you very clear ,if i am unable to communicate you well.
regards
venki
 

nsvmani

Board Regular
Joined
Jun 12, 2006
Messages
72
if i know your mailid, i could send my excel sheet how it should be processed when you run the macro.

Logic should be very simple for You.

Just need to do comparing the values on both sheets,
if the matching occured just skip the record in and start comparing the next record in Child sheet. If matching occured, then take that unmatched record from Child sheet and append it into end of Master sheet.
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hi,

Email or PM an example is somehow against the boardrules: we are working in team: sometimes it can be useful to email but for this case I don't see the need.
Isn't it easy to display a few rows of data for both sheets + the expected result ?

tools to use: Colo's htmlMaker (see bottom page) & Table-It (see my signature)

best regards,
Erik
 

Forum statistics

Threads
1,141,630
Messages
5,707,520
Members
421,512
Latest member
jc364698

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top