Results 1 to 6 of 6

Macro - If adjacent cell contains any data, then copy data from another cell. Possible?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-06-2012
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    165

    Macro - If adjacent cell contains any data, then copy data from another cell. Possible?

    Hi,

    I wondering if it is possible for a macro to recognise whether or not there is text in an adjacent cell, and if there is, then to copy data from another adjacent cell.

    For example, because there is data in C2, data from A2 has been inputted into B2. And any blank cells are left alone.


    a b c d e
    ref1 (cell A2 data here) DATA DATA DATA
    ref1

    Any ideas/help would be very much appreciated.
    Last edited by BPSJACK; 07-15-2014 at 06:04 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to copy data from one cell to another if adjacent cell meets certain requirements?
    By rrokicki in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-08-2016, 07:41 AM
  2. Copy Cell data if adjacent cell is empty
    By rflorentino in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-12-2014, 02:34 PM
  3. [SOLVED] match cell data & copy adjacent data
    By moin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-24-2013, 01:46 AM
  4. [SOLVED] Copy adjacent cell data based on ranged criteria.
    By Nneakz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-05-2013, 03:30 PM
  5. Find data and copy adjacent cell
    By hockeyadc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2012, 02:35 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