+ Reply to Thread
Results 1 to 12 of 12

few more lines of code to move cell contens to new range.

  1. #1
    Registered User
    Join Date
    02-27-2013
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    38

    few more lines of code to move cell contens to new range.

    Copy of EX DAYS DEBONE ROTATION SHEET(this one).xlshi forum ,

    i have a worksheet where every day i have to remove some names,
    which are divided into groups but there position are dynamic.
    what this code do is find what i looking for and put a color on the cell for each person.

    could someone help me help me changing this code, so every time it finds what im looking for, move the cell contents into a new range.

    im trying to do my self but with no luck .



    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: few more lines of code to move cell contens to new range.

    move the cell contents into a new range.

    Move to where? Need clear content after move?
    -If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".

    -Always upload a workbook before start your question
    To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

    +++ If my answer(s) helped you, please add me reputation by click on * +++

  3. #3
    Registered User
    Join Date
    02-27-2013
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    38

    Re: few more lines of code to move cell contens to new range.

    Quote Originally Posted by wenqq3 View Post
    move the cell contents into a new range.

    Move to where? Need clear content after move?
    the new range would start at H32 TO H.... and clear contents

  4. #4
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: few more lines of code to move cell contens to new range.

    Please Login or Register  to view this content.
    Is this what you mean?

  5. #5
    Registered User
    Join Date
    02-27-2013
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    38

    Re: few more lines of code to move cell contens to new range.

    Quote Originally Posted by wenqq3 View Post
    Please Login or Register  to view this content.
    Is this what you mean?
    thank you a lot finally my project is moving forward.

  6. #6
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: few more lines of code to move cell contens to new range.

    Great is helped

    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    + Mark your thread as Solved +

  7. #7
    Registered User
    Join Date
    02-27-2013
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    38

    Re: few more lines of code to move cell contens to new range.

    without trying to push to much would be possible to extend this macro so that would also find the names in
    sheet(A LINE).RANGE("C6:C11,C13:C11,C20:C24") .

    like this i would have one less button to press.

  8. #8
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: few more lines of code to move cell contens to new range.

    Please Login or Register  to view this content.
    This okie?

  9. #9
    Registered User
    Join Date
    02-27-2013
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    38

    Re: few more lines of code to move cell contens to new range.

    Quote Originally Posted by wenqq3 View Post
    Please Login or Register  to view this content.
    This okie?
    sorry for late reply!


    just one problem the names found in "A LINE" SHEET would have to be appended on to column H on sheet "EX11.5" like the others if possible.

  10. #10
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: few more lines of code to move cell contens to new range.

    Please Login or Register  to view this content.
    Check this OKIE?

  11. #11
    Registered User
    Join Date
    02-27-2013
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    38

    Re: few more lines of code to move cell contens to new range.

    Quote Originally Posted by wenqq3 View Post
    Please Login or Register  to view this content.
    Check this OKIE?
    just what i wanted. if i was going to do myself, another 10 years and I would still scratching my head.

    just one question how many years you been learning programming ?

  12. #12
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: few more lines of code to move cell contens to new range.

    Haha, few years. Logic is same, you can start from your favorite language.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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