Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
carry over data to other sheet - help needed
Dear excel specialists! Please help me with problem I have. I would like to carry over data from one sheet to another but of course under special conditions. Example: I have a table with many information about articles. On other sheet I have few positions for which I need only few information from the first sheet. It's little difficult to explain, so I've added a excel table showing the problem and solution I used till now. Thank you! Regards, Ines +-------------------------------------------------------------------+ |Filename: example.zip | |Download: http://www.excelforum.com/attachment.php?postid=5033 | +-------------------------------------------------------------------+ -- Svea ------------------------------------------------------------------------ Svea's Profile: http://www.excelforum.com/member.php...o&userid=28151 View this thread: http://www.excelforum.com/showthread...hreadid=561442 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
carry over data to other sheet - help needed
In inquiry,
Put in B2: =INDEX(database!B:B,MATCH(A2,database!A:A,0)) Copy down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Svea" wrote: Dear excel specialists! Please help me with problem I have. I would like to carry over data from one sheet to another but of course under special conditions. Example: I have a table with many information about articles. On other sheet I have few positions for which I need only few information from the first sheet. It's little difficult to explain, so I've added a excel table showing the problem and solution I used till now. Thank you! Regards, Ines +-------------------------------------------------------------------+ |Filename: example.zip | |Download: http://www.excelforum.com/attachment.php?postid=5033 | +-------------------------------------------------------------------+ -- Svea ------------------------------------------------------------------------ Svea's Profile: http://www.excelforum.com/member.php...o&userid=28151 View this thread: http://www.excelforum.com/showthread...hreadid=561442 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
carry over data to other sheet - help needed
Dear Max, Thank you so much for your reply. I will use this formula in daily business and remember Max from Singapore :) Thanks again. I have also visited savefile.com site and downloaded your examples. I think I will learn a lot from there. So happy!:) Best regards, Svea from Croatia (Europe) -- Svea ------------------------------------------------------------------------ Svea's Profile: http://www.excelforum.com/member.php...o&userid=28151 View this thread: http://www.excelforum.com/showthread...hreadid=561442 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
carry over data to other sheet - help needed
You're welcome, Svea! Appreciated your feedback.
We're quite global around here <g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Svea" wrote: Dear Max, Thank you so much for your reply. I will use this formula in daily business and remember Max from Singapore :) Thanks again. I have also visited savefile.com site and downloaded your examples. I think I will learn a lot from there. So happy!:) Best regards, Svea from Croatia (Europe) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Merger Two Data Sheet | Excel Discussion (Misc queries) |