+ Reply to Thread
Results 1 to 5 of 5

VB Code to Copy certain text based on number of data

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    VB Code to Copy certain text based on number of data

    Hello:

    Please refer to attached file.
    I need VB Code to do following.

    Number is items in column A in this example is 11.
    Number is stores in column C in this example is 5.
    So i need to have starting at cell E2:

    11 text ABC
    11 text CDF
    11 text XBG
    11 text ASM
    11 text AKI

    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: VB Code to Copy certain text based on number of data

    How about
    Please Login or Register  to view this content.

  3. #3
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: VB Code to Copy certain text based on number of data

    Since I did this before Fluff's post, FWIW:
    Please Login or Register  to view this content.

  4. #4
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to Copy certain text based on number of data

    Hello Fluff13:

    Thanks a lot...works

    Riz

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: VB Code to Copy certain text based on number of data

    You're welcome & thanks for the feedback

+ 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. Event Change code to copy paste cells based on the text of a cell
    By ds9703c in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2018, 01:21 PM
  2. Copy down text in columns until next part number - VBA Code
    By CC268 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2017, 06:36 PM
  3. copy number to different worksheet based on text in previous cells.
    By naccas1990 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-11-2015, 12:58 AM
  4. Copy and paste data from master based on a specific format based on Invoice number
    By anandnair1983 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2015, 06:32 AM
  5. Replies: 0
    Last Post: 09-28-2015, 06:32 AM
  6. vba code to copy number of rows in based on the input message
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2014, 12:38 AM
  7. Code to find text, copy rows into new worksheet, based on relative selection
    By tribes712 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-21-2010, 11:32 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