+ Reply to Thread
Results 1 to 4 of 4

To Find every instance of TEXT copy, repeat until no Find found

  1. #1
    Registered User
    Join Date
    05-30-2013
    Location
    US
    MS-Off Ver
    2013
    Posts
    67

    To Find every instance of TEXT copy, repeat until no Find found

    So here is what I need to have happen. Excuse me the code and excel file I have attached are seperate to prevent user data on the web I created the test file based from the Quickbooks data file I use for multiple excel macros.

    I am trying to automate the process of creating a dynamic list based upon the test file attached. I want it to find every instance of the word "Bill Pmt -Check" in column B and copy the business name once it finds the word "Bill Pmt-Check" that is in column H of the same row. I would like it to continue until it cannot find another Bill Pmt-Check.

    Here is what I have tried so far and I think it might be bad programming: ie I have it first searching for the number of instances of the word Bill Pmt -Check and recording that value in a cell. Then it stops copying business names once it hits that value of the cell aka the number of businesses it copies stops when it reaches the total NUMBER of businesses.'

    This script is not working as it records the value 0 still:

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: To Find every instance of TEXT copy, repeat until no Find found

    DadaaP,

    Give this a try:
    Please Login or Register  to view this content.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    05-30-2013
    Location
    US
    MS-Off Ver
    2013
    Posts
    67

    Red face Re: To Find every instance of TEXT copy, repeat until no Find found

    Have not used much in the way of arrays go. Thank you very very much for the code, I now understand how to use arrays.

    Code works great and am editing the msg box to return a Yes or No prompt with the array whether the user agrees with the values that will be provided for the macro.

    Thank you tigeravatar!!!!

  4. #4
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: To Find every instance of TEXT copy, repeat until no Find found

    You're very welcome

+ 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. Replies: 2
    Last Post: 04-11-2013, 11:14 AM
  2. [SOLVED] Macro to find text and if found, copy an adjacent cell into a different cell
    By Raulus in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-22-2012, 09:57 AM
  3. [SOLVED] Find first and last instance of text in column range multiple times
    By ShannonHowell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-24-2012, 11:52 AM
  4. Find&Copy only copying 1 instance of match
    By SarahPintal in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-14-2010, 10:55 AM
  5. code to find, copy and paste until find new, then repeat
    By siddharthariver in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2010, 04:02 PM

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