Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inputting data to one worksheet for it effect another daedalus1 Excel Discussion (Misc queries) 1 June 25th 06 04:39 PM
ranking query JaimeTimbrell Excel Discussion (Misc queries) 2 February 16th 06 09:09 AM
Importing Data Jillian Excel Worksheet Functions 9 December 23rd 05 01:45 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Merger Two Data Sheet Charles Excel Discussion (Misc queries) 2 March 18th 05 04:35 PM


All times are GMT +1. The time now is 03:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"