Results 1 to 7 of 7

Thread: Help needed - Extracting rows from excel sheet based on a value

  1. #1

    Help needed - Extracting rows from excel sheet based on a value



    Register for a FREE account, and/
    or Log in to avoid these ads!

    i have the following excel sheet which has data that is coming to me in the format as shown in "input" tab. I would like to read the sheet and output the data in the format as shown in "output" tab.

    new to macros...If there is a macro that can do this, that would be great.

    Thanks for your help.
    Attached Files Attached Files

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Test1.xlsx No macros needed. See attached.

  3. #3

    not sure what you did...can you explain?

    Quote Originally Posted by JeffreyWeir View Post
    Test1.xlsx No macros needed. See attached.
    not sure what you did...can you explain? It looks like the same file that I provided in my question.
    please note that Input tab contains the format of the records (sample given for 4)....But I have 1000's of those that I need to read thru and extract the rows and put them in columns....

  4. #4
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Open the file, click on any cell in colmuns A, C, D, E in column B that has something in it, and you'll see that there's a formula in it that pulls data from the INPUT sheet based on the value in column B.

  5. #5
    Quote Originally Posted by JeffreyWeir View Post
    Open the file, click on any cell in colmuns A, C, D, E in column B that has something in it, and you'll see that there's a formula in it that pulls data from the INPUT sheet based on the value in column B.
    Thanks, Jeffery. It works, if I know the Column B value.

    What I am looking is, scan the input sheet and extract the required row values ...format them in the output format. The control break for each set is, the row values in A1, A7, A13 and A19.

    Thanks

  6. #6
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Test1 (1).xlsx

    Okay, see the attached. Note that I've applied a custom number format to column B so that zeros don't display in the event that we've reached the bottom of the list.

    Note that this relies on you having the exact structure you currently have in the Input tab. Insert extra rows, and this will break.

  7. #7
    Quote Originally Posted by JeffreyWeir View Post
    Test1 (1).xlsx

    Okay, see the attached. Note that I've applied a custom number format to column B so that zeros don't display in the event that we've reached the bottom of the list.

    Note that this relies on you having the exact structure you currently have in the Input tab. Insert extra rows, and this will break.
    Thanks. Let me test this...

    If I have extra rows and format is same , should I adjust the formula? Currently I have 6 rows per set. If I have 10 rows, what precautions should I take?

Posting Permissions

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