+ Reply to Thread
Results 1 to 1 of 1

Issue with Current Code to Copy Paste Cells Inside a Table

  1. #1
    Registered User
    Join Date
    11-23-2017
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    4

    Issue with Current Code to Copy Paste Cells Inside a Table

    Hello ,

    the goal of my code is to:

    Find "[term] - Competency" inside the sheet called "Data", and then:

    1) Highlights the cell "[term] - Competency" in yellow
    2) it looks for "[term] - [level of effort]" that has something written on the cell on the right from it.
    3) Highlights the cell "[term] - [level of effort]" in purple
    4) Copy the two cells on the right from it and pastes it next to "[term] - Competency"

    This is the issue I am having:

    Once the code has finished step 1, it is supposed to look for the cells below it and continue on step 2,3,4 But in the instances that it did not work, It identified the cell above it instead, which is empty, hence why it doesn't copy paste the details.

    For example: Instead of the cell identifying "Connect - Low Effort" that is below "Connect - Competency", it identified the cell that was above it.
    Attached is an illustration called "Demonstration of the issue" that shows the example above.

    I don't understand why it does identify the one above in certain instances and why it does not in other instances.

    Here is my code: (attached is the excel file "Data with issues")

    Please Login or Register  to view this content.
    I appreciate any help given. Thank you.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by VanChester; 11-23-2017 at 11:53 PM.

+ 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] VBA - Macro issue copy/paste line other sheet + duplicate current sheet
    By vcourbiere in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-17-2014, 12:06 PM
  2. [SOLVED] copy and paste in current active cell, and need current date then scroll down 140 lines
    By vengatvj in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2013, 03:40 AM
  3. [SOLVED] Changing Current Code from Paste Formulas to Paste Values
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-24-2013, 12:33 PM
  4. [SOLVED] Copy and Paste Cells with Formulas inside
    By camillecamille in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2013, 05:16 PM
  5. Replies: 1
    Last Post: 10-17-2012, 02:33 AM
  6. Issue - white space inside code tags
    By Andrew-R in forum Suggestions for Improvement
    Replies: 11
    Last Post: 04-24-2012, 05:52 AM
  7. Code not working exactly, copy and paste issue
    By jpthelpguy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2009, 01:42 PM

Tags for this Thread

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