+ Reply to Thread
Results 1 to 10 of 10

Find datas in on excel sheet from another?

  1. #1
    Registered User
    Join Date
    06-16-2012
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    14

    Find datas in on excel sheet from another?

    Hello,
    I need some help. I attached a document where I explain my problem:


    Sheet 1:
    Problem

    Sheet 2
    Full data

    Sheet 3:
    My numbers

    Sheet 4:
    How I want it!

    Would be great if any one can give me a detailed explenation about how I can fix this!

    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Find datas in on excel sheet from another?

    Need some Inputs:-

    1) Are you looking for Formula solution or Macro Code solution.
    2) How the values are arrived in sheet3? based on single asterisk in Column-F of sheet2?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    06-16-2012
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Find datas in on excel sheet from another?

    1) Are you looking for Formula solution or Macro Code solution.
    The esiest and quickest one! I hope that answer is enough!

    2) How the values are arrived in sheet3? based on single asterisk in Column-F of sheet2
    I dont quite under stand your question. But I hope this will help you:

    Sheet 2 is a list which contains all of my companys products

    Sheet 3 is a list of Art nr I get from Marketing. This is a set of products they want in a new campaign. My job is to supplement these Art nr with the data from sheet 2. I got booth sheet 2 and the in simple .xlsx.

    Hope this is enough!?

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Find datas in on excel sheet from another?

    In Sheet4 - A2 cell
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Drag the formula down and right.

    Adapt the range reference to your data if your data size is higher than the example data.

  5. #5
    Registered User
    Join Date
    06-16-2012
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Find datas in on excel sheet from another?

    But where should I do this?

    Maybe this is to much work for you, but it would be awesome if you can do a step-by-step guide how you do this?

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Find datas in on excel sheet from another?

    I don't know how I can help you in further...

    1) First select sheet4
    2) Then Place the cursor in A2 cell
    3) Copy the below formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    4) paste the formula (i.e. in A2 cell)
    5) Drag the A2 cell down and right to fill it for remaining cells.

  7. #7
    Registered User
    Join Date
    06-16-2012
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Find datas in on excel sheet from another?

    edit second try...

  8. #8
    Registered User
    Join Date
    06-16-2012
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Find datas in on excel sheet from another?

    Hmm.. When I paste the formula into A2 (Sheet 4) I just get a wrong message which says its something wrong with the formula...

  9. #9
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Find datas in on excel sheet from another?

    No the formula don't result error or any error message if you have the sheets in the workbook.

  10. #10
    Registered User
    Join Date
    06-16-2012
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Find datas in on excel sheet from another?

    Here is a filmclip which shows how I clip in the form... Probably I'm doing it wrong somewhere...:P


    http://youtu.be/3fU5jFXu2uE

    Sorry for being in swedish, but the end pop up is just the standard which informs me that its something wrong with the formula

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1