+ Reply to Thread
Results 1 to 2 of 2

Finding Text, Offsetting, then Filling Cell with Value

  1. #1
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    228

    Finding Text, Offsetting, then Filling Cell with Value

    Hello Everyone!

    I'm looking to update some code that I wrote a while back, but I'm having trouble fitting the new specs in. Quick overview of what this does - It grabs files in a folder one by one, copies them, and pastes them in a new workbook so they are all on one sheet, it then takes the value from A4, and copies and autofills it down the length of each file copied. I just added the part where it fills in "January" and autofills that down. However, what I'm looking to do now is have the code find "Hello There", offset 3 columns to the left, and the value from there down should be "February" instead of "January".

    Please Login or Register  to view this content.
    Let me know if you have any questions or need any other info!

    Thanks in advance!

  2. #2
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    228

    Re: Finding Text, Offsetting, then Filling Cell with Value

    Update... I've actually figured out the main issue with my code where I couldn't get "February" to populate. My issue now is getting it to autofill down over some of the "January" cells. Here is my new code:

    Please Login or Register  to view this content.
    Could someone please help me with that last autofill after "February" is inserted? It should go from that cell to the last row.

    Thanks again!

+ 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. [SOLVED] offsetting text from blank cells
    By milo1984 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-14-2016, 06:23 PM
  2. finding and selecting first empty cell in a column and offsetting it
    By nosense in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-10-2015, 06:04 PM
  3. [SOLVED] Offsetting Referenced Cell After Finding Value Equal to or Greater Than X
    By stusic in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-27-2013, 12:31 PM
  4. Replies: 3
    Last Post: 03-17-2013, 02:52 PM
  5. Filling in text to the left and right of a cell
    By kapakra in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-11-2007, 05:50 AM
  6. Filling a large cell with text
    By markwilest in forum Excel General
    Replies: 2
    Last Post: 06-01-2007, 01:57 PM
  7. [SOLVED] Finding a value and filling in data
    By Angie M. in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2006, 10:40 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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06837 seconds
  • Memory Usage 8,896KB
  • 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
  • (2)bbcode_code
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (2)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (2)postbit_legacy
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (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
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (48):
  • 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_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1