Results 1 to 4 of 4

Copy range after specific criteria is found

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-10-2012
    Location
    Slovakia
    MS-Off Ver
    Excel 365
    Posts
    174

    Copy range after specific criteria is found

    Hi,

    I would like kindly ask you with my request and help me to write some macro which can cover it. Maybe it will be quite harder for me to explain it, but I try my best.

    I got some converted data from .pdf in excel (Sheet: "Case") and now I am trying to merge some important data together in 2nd sheet (Sheet: "Result").

    There are 2 tasks which need to be done.

    TASK 1:
    Step1: I need to find the first "key word" which is "Account"
    Step2: Copy names from column 'B' (highlighted by yellow) if there is a Actor condition in specific range (range = rows under "Account" up to first blank row. In my example, up to row 18)
    Step3: Paste it to sheet "Result" in cell 'C2'

    TASK 2:
    Step1: I need to find second "key word" which is "BATMAN"
    Step2: Copy list of masks from column 'E' (highlighted by yellow), where beginning of range is 2 rows under BATMAN and ended by last filled row in column "D" =
    Step3: Paste it to sheet "Result" after the last filled row in column 'C'

    I believe that attached example file where you can find highlighted cells in example sheets make more sense for you than my wording above :-).

    Thank you in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 01-04-2020, 09:46 AM
  2. [SOLVED] Search for value in row. if found, copy column formulas into found column range
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2017, 10:42 AM
  3. Replies: 10
    Last Post: 11-04-2015, 05:19 AM
  4. Replies: 4
    Last Post: 08-04-2014, 04:48 AM
  5. [SOLVED] Copy range based on specific criteria
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 07-03-2014, 05:06 PM
  6. [SOLVED] Would like to copy rows until specific value is found
    By caooi23 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-07-2013, 01:41 AM
  7. [SOLVED] Copy data to specific range in another Book based on conditional criteria
    By khatibcell in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-16-2013, 02:39 AM

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