+ Reply to Thread
Results 1 to 8 of 8

How to use the sheet 1 data in the sheet 2???

  1. #1
    Registered User
    Join Date
    07-06-2012
    Location
    chennai
    MS-Off Ver
    Excel 2003
    Posts
    12

    How to use the sheet 1 data in the sheet 2???

    I have few cells in Sheet 1 with some values selected from the drop down list.

    Ex:
    Cell No: 3
    DropDown1: ABC
    DropDown2: CDE
    DropDown3: FGH
    Dropdown4: IJK

    And have a command button in sheet 1, when selected it,

    The data in sheet 1 should be used in Sheet 2 like below,

    1) 'ABC' is first 3 characters
    2) 'CDE' is second 3 characters
    3) 'FGH' is 3rd 3 characters
    4) 'IJK' is the next 3 characters

    All 4 lines should be displayed within a single cell, that is in cell A3 as 3 is selected as cell No in sheet 1.

    How to use macro to perform the above operation?

  2. #2
    Forum Contributor
    Join Date
    07-05-2012
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2016
    Posts
    165

    Re: How to use the sheet 1 data in the sheet 2???

    Can you provide a sample workbook?

  3. #3
    Registered User
    Join Date
    07-06-2012
    Location
    chennai
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: How to use the sheet 1 data in the sheet 2???

    Attached the sample sheet.

    When 'Create Result' button is selected in the data sheet, Appropriate data should be populated in the result sheet as given.

    Please provide the macro code for this operation.

    Thanks.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    07-05-2012
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2016
    Posts
    165

    Re: How to use the sheet 1 data in the sheet 2???

    Are there always going to be a set number of components or is the size dynamic?

  5. #5
    Registered User
    Join Date
    07-06-2012
    Location
    chennai
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: How to use the sheet 1 data in the sheet 2???

    Thanks for your reply. :-)

    It should be dynamic. Attributes may increase. i.e It may increase to Line 7, Line 8 and so on. Also there can be 1 or more data for each attribute. i.e There may be one more data column.

    Is it possible to have a macro written for this??

  6. #6
    Registered User
    Join Date
    07-06-2012
    Location
    chennai
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: How to use the sheet 1 data in the sheet 2???

    Can anyone pls help me to get a solution for this.

    Thanks.

  7. #7
    Forum Contributor
    Join Date
    07-05-2012
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2016
    Posts
    165

    Re: How to use the sheet 1 data in the sheet 2???

    Let's say that there is a second data column(first data column 'B' and second data column 'C') for row number 2.

    B2 = ABC | C2 = XYZ
    B3 = DEF
    B4 = GHI

    Should the script put it in order of column ("ABCDEFGHIXYZ") or in order by row ("ABCXYZDEFGHI")?

  8. #8
    Forum Contributor
    Join Date
    07-05-2012
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2016
    Posts
    165

    Re: How to use the sheet 1 data in the sheet 2???

    Tell me if this works for you.

    Please Login or Register  to view this content.
    If it doesn't, please tell me what changes need to be made.
    Attached Files Attached Files
    Last edited by Xer2; 07-09-2012 at 12:38 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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