+ Reply to Thread
Results 1 to 14 of 14

Find text, if not paste in the first blank cell

  1. #1
    Forum Contributor
    Join Date
    08-10-2010
    Location
    Tavira, POrtugal
    MS-Off Ver
    Excel 2010
    Posts
    132

    Find text, if not paste in the first blank cell

    hello. I'm trying to make a macro to find a specific text, and if not available, this same text to be inserted into the first blank cell.
    The macro to find Is already inserted in the project, now I just need the part of in case does not find the text, paste it in the first blank cell.
    what I want to do is place the text, not found in the first blank cell in column A. in this case line 7 of column A.
    For example: if you do not find the word "line" in column A, the macro would paste that word in the blank line immediately below. in this case line 7.

    first of all thanks for the help.
    Attached Files Attached Files
    Last edited by Birnen; 05-12-2012 at 12:03 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,242

    Re: Find text, if not paste in the first blank cell

    What 1st blank cell do you want the value? Is it a specific row or a specific column?

    When this is explained, you do not have to paste the value.

    1st blank row=datafind

  3. #3
    Forum Contributor
    Join Date
    08-10-2010
    Location
    Tavira, POrtugal
    MS-Off Ver
    Excel 2010
    Posts
    132

    Re: Find text, if not paste in the first blank cell

    what I want to do is place the text, not found in the first blank cell in column A. in this case line 7 of column A.
    For example: if you do not find the word "line" in column A, the macro would paste that word in the blank line logs below. in this case line 7.
    Last edited by davesexcel; 05-12-2012 at 08:42 AM.

  4. #4
    Valued Forum Contributor StevenM's Avatar
    Join Date
    03-23-2008
    Location
    New Lenox, IL USA
    MS-Off Ver
    2007
    Posts
    910

    Re: Find text, if not paste in the first blank cell

    Add:

    Please Login or Register  to view this content.
    Sometime after:

    Please Login or Register  to view this content.
    And Before:

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    08-10-2010
    Location
    Tavira, POrtugal
    MS-Off Ver
    Excel 2010
    Posts
    132

    Re: Find text, if not paste in the first blank cell

    you can put directly in the project because I am afraid of doing something wrong.
    thank you
    Last edited by davesexcel; 05-12-2012 at 08:41 AM.

  6. #6
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,242

    Re: Find text, if not paste in the first blank cell

    Your code loops through all the sheets in your workbook searching for the the inputbox criteria, is the inputbox criteria supposed show up on each worksheet that returns no results?

  7. #7
    Forum Contributor
    Join Date
    08-10-2010
    Location
    Tavira, POrtugal
    MS-Off Ver
    Excel 2010
    Posts
    132

    Re: Find text, if not paste in the first blank cell

    yes, if not found the specifi text.

  8. #8
    Forum Contributor
    Join Date
    08-10-2010
    Location
    Tavira, POrtugal
    MS-Off Ver
    Excel 2010
    Posts
    132

    Re: Find text, if not paste in the first blank cell

    I made the change as you said, but nothing done. it does not puts the word in the right direction. and do not stop the search for value.
    Last edited by davesexcel; 05-12-2012 at 09:06 AM. Reason: You do not need to quote, previous posts, it looks tacky.

  9. #9
    Valued Forum Contributor StevenM's Avatar
    Join Date
    03-23-2008
    Location
    New Lenox, IL USA
    MS-Off Ver
    2007
    Posts
    910

    Re: Find text, if not paste in the first blank cell

    Try this:

    Please Login or Register  to view this content.

  10. #10
    Forum Contributor
    Join Date
    08-10-2010
    Location
    Tavira, POrtugal
    MS-Off Ver
    Excel 2010
    Posts
    132

    Re: Find text, if not paste in the first blank cell

    You do not have to quote every single post.

    with this macro is already putting the word when it is not found, but does not select the word when it already exists.
    thank you for your help.
    let's see if I can do that select pre-existing words.
    I'll have to put this macro with one of the parties of my first macro. correct?
    Last edited by davesexcel; 05-12-2012 at 09:15 AM.

  11. #11
    Valued Forum Contributor StevenM's Avatar
    Join Date
    03-23-2008
    Location
    New Lenox, IL USA
    MS-Off Ver
    2007
    Posts
    910

    Re: Find text, if not paste in the first blank cell

    Select cell found selected.

    Please Login or Register  to view this content.

  12. #12
    Forum Contributor
    Join Date
    08-10-2010
    Location
    Tavira, POrtugal
    MS-Off Ver
    Excel 2010
    Posts
    132

    Re: Find text, if not paste in the first blank cell

    Quote Originally Posted by StevenM View Post
    Select cell found selected.

    Please Login or Register  to view this content.
    thank you very much, is excellent.

    one more thing. is it possible the cell where the word was inserted by not being available, be selected. such as when the word is already there.
    Last edited by Birnen; 05-12-2012 at 09:50 AM.

  13. #13
    Valued Forum Contributor StevenM's Avatar
    Join Date
    03-23-2008
    Location
    New Lenox, IL USA
    MS-Off Ver
    2007
    Posts
    910

    Re: Find text, if not paste in the first blank cell

    is it possible the cell where the word was inserted by not being available, be selected. such as when the word is already there.
    Please Login or Register  to view this content.
    Last edited by StevenM; 05-12-2012 at 10:09 AM. Reason: Notes added

  14. #14
    Forum Contributor
    Join Date
    08-10-2010
    Location
    Tavira, POrtugal
    MS-Off Ver
    Excel 2010
    Posts
    132

    Re: Find text, if not paste in the first blank cell

    Quote Originally Posted by StevenM View Post
    Please Login or Register  to view this content.
    work 5 stars
    thank you, I do not know how to thank you

+ 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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.07624 seconds
  • Memory Usage 9,216KB
  • Queries Executed 15 (?)
More Information
Template Usage (34):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (8)bbcode_code
  • (4)bbcode_quote
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (14)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (1)postbit_attachment
  • (14)postbit_legacy
  • (14)postbit_onlinestatus
  • (14)postbit_wrapper
  • (4)showthread_bookmarksite
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (47):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1