| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cross Excel Updation
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Microsoft Excel OLE link not updation in German XP OS | Excel Discussion (Misc queries) | |||
| Automatic Excel data updation on Sharepoint. | Excel Discussion (Misc queries) | |||
| updation in farmulae | Excel Discussion (Misc queries) | |||
| Excel Problem in detail/updation, deletion | Excel Programming | |||
| Excel VBA - Userform updation/deletion problem | Excel Programming | |||
Threaded Mode
