+ Reply to Thread
Results 1 to 7 of 7

Excel Data Extraction Macro/VBA

  1. #1
    Registered User
    Join Date
    03-27-2012
    Location
    Durham, NC
    MS-Off Ver
    Excel 2010 For Windows & Excel 2011 for Mac.
    Posts
    2

    Excel Data Extraction Macro/VBA

    Do you know of any macros that would search through an excel spreadsheet to find values greater than or less than a certain value then extract that row containing that data to another spreadsheet? Or even a macro that could extract data from a PDF then put it into a Excel Spreadsheet? Is this feasible?

    Thanks,

    Any help would be extremely helpful.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,517

    Re: Excel Data Extraction Macro/VBA

    There are lots of ways to extract information from a worksheet, you will have to be more specific in the details.
    There is no macro that I am aware of that can grab information from a PDF.

  3. #3
    Registered User
    Join Date
    03-27-2012
    Location
    Durham, NC
    MS-Off Ver
    Excel 2010 For Windows & Excel 2011 for Mac.
    Posts
    2

    Re: Excel Data Extraction Macro/VBA

    Okay thanks. Basically, have series of columns that contain information such as name, address, phone number, etc, property value. I'm trying to find certain data within the table that has a property value greater than x (x>p). I need find a way to extract that data to another sheet. So for example if the property value I'm looking for is x>2000. I want to be able to run a macro that will find that value and extract the entire row that includes that value and other information (name, address, phone number, etc.) Hopefully, that makes sense. I feel like there's probably a post on on this forum that does this exactly. I just can't find it.

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,517

    Re: Excel Data Extraction Macro/VBA

    It would be best to supply a sample workbook, that shows what your original layout is and what your results should be.
    When you reply hit the advanced button, then hit the paper-clip to attach a sample workbook.

  5. #5
    Registered User
    Join Date
    03-28-2012
    Location
    San Salvador
    MS-Off Ver
    2010
    Posts
    3

    Re: Excel Data Extraction Macro/VBA

    Are you looking this value on a single column or is it in the whole range/table?
    -Jorge

  6. #6
    Registered User
    Join Date
    03-26-2012
    Location
    Clovis, New Mexico
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Excel Data Extraction Macro/VBA

    I have the same question. I am trying to extract rows from a spreadsheet that has multiple records of the same account number. I will have a hard time explaining it so I will attach a sample to this post. Please note the formulas (which I got somewhere else in the forum) in Column M and Column N. These are so I can sort out the different account types and add up all the dividends. I would like to extract all dividends calculated in column N that are greater than $9.94. I am looking to keep all the address information attached. Sample Workbook.xlsx

  7. #7
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,517

    Re: Excel Data Extraction Macro/VBA

    Quote Originally Posted by tindercd View Post
    .......... in column N that are greater than $9.94. I am looking to keep all the address information attached. Attachment 147738
    You have not indicated what you want done with the filtered data.
    Please Login or Register  to view this content.

+ 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