+ Reply to Thread
Results 1 to 3 of 3

Macro to Autofill number/formula until it reaches cell containing specific text

  1. #1
    Registered User
    Join Date
    08-30-2012
    Location
    england
    MS-Off Ver
    Excel 365 MSO
    Posts
    10

    Macro to Autofill number/formula until it reaches cell containing specific text

    Hi,

    I want a macro that will copy the contents of O1 in every row of column L until it reaches the word department in column A.
    But then when it has stopped at the word department I want it to copy the contents of O2 in every row after that.

    Sounds a bit complicated but can anyone help please?

  2. #2
    Forum Contributor
    Join Date
    08-09-2012
    Location
    Anch, Alaska
    MS-Off Ver
    2003, 2010, 2013
    Posts
    131

    Re: Marco to Autofill number/formula until it reaches cell containing specific text

    Give this a try, copy this macro into your Sheet Module.
    The code stops at Row 1000, you can always adjust it to your row needs.

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    08-09-2012
    Location
    Anch, Alaska
    MS-Off Ver
    2003, 2010, 2013
    Posts
    131

    Re: Marco to Autofill number/formula until it reaches cell containing specific text

    If your happy with your answer, be sure to mark you post as [Solved].
    At the Top Right of your Post You can:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    You can also give credit by clicking on the Star at the bottom left of the supporting post.
    Give Credit When Credit Is Due - Click On the Star
    Be Sure To Mark Your Post [Solved] When You Get Your Answer

+ 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