Page 2 of 2 FirstFirst 1 2
Results 11 to 12 of 12

Thread: how to copy data with multiple cases matched.

  1. #11
    Acolyte Zshan's Avatar
    Join Date
    Apr 2020
    Posts
    29
    Articles
    0
    Excel Version
    Excel10


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

    Hi,

    Thanks for writing a code for me its great it works just fine!

    Now you know what I was needed earlier, let's suppose I have sheet called "OUTPUT" which contains few Rows of column "A" text = "CLEAR",
    if I want last entry of " CLEAR " to be focused,
    just 1 Row below this "CLEAR" row remains,
    every row below this 1 row to the last filled row of column "B" would be deleted,
    in this 1 row in column "D" ,"E","F","G","J" & "K" would be cleared!

    Remember this process is just for the last "CLEAR" entry (from downwards to upwards it'd be the first) & not for every "CLEAR" entry the sheet contains,

    any suggestion what would be the code for that purpose!
    waiting for your reply!

    Thanks again.

  2. #12
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    824
    Articles
    0
    Excel Version
    Excel 2010
    any suggestion what would be the code for that purpose!
    Using the macro recorder while manually doing this will give you the basis for the coding required.

Page 2 of 2 FirstFirst 1 2

Posting Permissions

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