+ Reply to Thread
Results 1 to 7 of 7

Pick up data from the table

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    12-23-2009
    Location
    Serbia
    MS-Off Ver
    Excel 2007
    Posts
    180

    Pick up data from the table

    Hello guys,i have one task to solve today and i hope that you can help me again.

    I have two tables,first is Table 1 where i fill the data manually and i want to pick up data from this Table and fill the Table 2 in the Sheet 2,can i do this automatically after fill cells in Table 1 and the Table 2 have to be created in form as i described in my Sample.

    If you have some suggestion of\r question im here and we can start conversation.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Pick up data from the table

    Your example is not clear to me.

    Table 1
    8017 9016
    A191 M11010 M11011 M11012 6000 23 25

    the red tekst I don't find in your table 2 => why not?
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Contributor
    Join Date
    12-23-2009
    Location
    Serbia
    MS-Off Ver
    Excel 2007
    Posts
    180

    Re: Pick up data from the table

    Hello oeldere,thank you for answer,

    For some reason i can't open my sample again ,i will attach again.

    As you can see M11011 is red in Table 1 and M11011 is red IN Table 2 also.

    Data in both tables are same but their destination was changed.

    Thank you again for replay.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Pick up data from the table

    See #2

    A191 M11010	M11011 M11012 6000 23	25
    
     the red tekst I don't find in your table 2 => why not?
    Also in your new file is NOT added in sheet 2 te values M11010 and 23

  5. #5
    Forum Contributor
    Join Date
    12-23-2009
    Location
    Serbia
    MS-Off Ver
    Excel 2007
    Posts
    180

    Re: Pick up data from the table

    Ok,now i see ,this data from Table 1 is not important,i do not need them in Table 2.

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Pick up data from the table

    If you don't want the data of sheet 1 (if they are not important), how does the sheet 2 need to be imputted?

  7. #7
    Forum Contributor
    Join Date
    12-23-2009
    Location
    Serbia
    MS-Off Ver
    Excel 2007
    Posts
    180

    Re: Pick up data from the table

    I need only data from the Table 1 to Table 2 which i put in my example ,rest of data are not important in this case.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot Table Pick
    By TimEd in forum Excel General
    Replies: 2
    Last Post: 07-04-2012, 03:26 AM
  2. Replies: 6
    Last Post: 03-11-2012, 09:28 AM
  3. Pick value from 2D Decision Table
    By nougain in forum Excel General
    Replies: 4
    Last Post: 11-04-2009, 05:59 AM
  4. i want to pick up some value's from a table
    By rusulucian85 in forum Excel General
    Replies: 4
    Last Post: 10-07-2008, 05:28 PM
  5. i want to pick up some values from a table
    By rusulucian85 in forum Excel General
    Replies: 1
    Last Post: 10-06-2008, 04:39 PM

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