+ Reply to Thread
Results 1 to 4 of 4

VBA - Extracting of Rows from Source Data

  1. #1
    Registered User
    Join Date
    03-25-2022
    Location
    UK
    MS-Off Ver
    Excel 2016
    Posts
    2

    VBA - Extracting of Rows from Source Data

    Hi all, hoping someone is able to assist with a problem that I had encountered.

    I will need to extract rows from source data using VBA with reference from a separate sheet.

    Are we able to extract based on cell number or do we have to insert another row in source data as an identifier for extraction? Most of the example that I've search on requires a criteria.

    I've attached the workbook for easy reference.

    Thanks!
    Last edited by 12323145; 03-26-2022 at 01:35 PM.

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,695

    Re: VBA - Extracting of Rows from Source Data

    Simple to adjust/change.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-25-2022
    Location
    UK
    MS-Off Ver
    Excel 2016
    Posts
    2

    Re: VBA - Extracting of Rows from Source Data

    Thanks, jolivanes!

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,695

    Re: VBA - Extracting of Rows from Source Data

    Thank you for letting us know.
    Somehow your attachment disappeared.
    People looking for a solution with the same or similar problem and ending up here sure will appreciate an attachment, as mentioned in your first post.
    So I have added the attachment with code included. There is no personal data in it.
    Attached Files Attached Files

+ 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. [SOLVED] Extracting data from external source time out
    By excelhelpguy123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2017, 09:25 AM
  2. Need help extracting data from web page source into excel using RegEx and macro
    By chococ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2014, 03:45 PM
  3. Replies: 3
    Last Post: 09-15-2013, 12:47 AM
  4. Extracting text/numbers form varying source data
    By Sybie in forum Excel General
    Replies: 4
    Last Post: 01-15-2013, 07:18 AM
  5. Extracting of data from a website using VBA or XML or data source connection
    By joelhuang in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-19-2010, 09:57 PM
  6. Extracting Delimited Data from an Online Source
    By OlYeller21 in forum Excel General
    Replies: 0
    Last Post: 07-19-2006, 10:42 AM
  7. Extracting source data that I want
    By Chris435435 in forum Excel General
    Replies: 2
    Last Post: 06-29-2006, 12:18 PM

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