PC Review


Reply
Thread Tools Rate Thread

Cross Excel Updation

 
 
test
Guest
Posts: n/a
 
      15th Mar 2009
Greetings,

I have a requirement where I need to update a parent excel based on a
child excel. I have to compare column A of child excel with Column A
of parent excel. Wherever we have equal values, I need to pick up
respective value from Column C and D from child excel and update
Column C and D of parent excel.

For eg:

Child Excel data

Column A ColumnC Column D
test1 value1 value1
test2 value2 value2

Parent Excel data

Column A ColumnC Column D
test0
test1
test2

Final result

Parent Excel data

Column A ColumnC Column D
test0
test1 value1 value1
test2 value2 value2

So wherever we have equal values in column A of both child and parent
excel, the respective values of Column C and Column D should be picked
up from Child excel and needs to be updated in section in Parent
excel.

Can anyone please let me know how this can be achieved.

TIA
 
Reply With Quote
 
 
 
 
Jacob Skaria
Guest
Posts: n/a
 
      15th Mar 2009
Greetings..

Paste this in parent excel
CoumnB =INDEX([Child]Sheet1!$B:$B,MATCH(A1,[Child]Sheet1!$A:$A))
CoumnC =INDEX([Child]Sheet1!$C:$C,MATCH(A1,[Child]Sheet1!$A:$A))
CoumnE =INDEX([Child]Sheet1!$D:$D,MATCH(A1,[Child]Sheet1!$A:$A))

If this post helps click Yes
--------------
Jacob Skaria


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Excel OLE link not updation in German XP OS Dibyendu Seal Microsoft Excel Misc 0 8th Sep 2009 07:16 PM
Excel Updation test Microsoft Excel Programming 5 22nd Mar 2009 10:00 AM
Automatic Excel data updation on Sharepoint. Raj Microsoft Excel Misc 0 13th May 2008 11:18 AM
Excel Problem in detail/updation, deletion programmer_int Microsoft Excel Programming 1 4th Sep 2004 09:56 PM
Excel VBA - Userform updation/deletion problem programmer_int Microsoft Excel Programming 1 4th Sep 2004 09:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:46 AM.