+ Reply to Thread
Results 1 to 1 of 1

A Macro to Copy and paste from cell above if certain Conditions are met

  1. #1
    Registered User
    Join Date
    02-12-2016
    Location
    Belfast, Northern Ireland
    MS-Off Ver
    MS Office 2007
    Posts
    1

    A Macro to Copy and paste from cell above if certain Conditions are met

    Hi

    I am new to VBA and not sure if I can achieve what I am looking to do in a macro.

    I am looking for a macro to copy and paste text from the nearest cell to the first cell below that meets two conditions.

    I have shown a very simple example of what I would like the macro to look like before and after macro run.

    It may seem simple but its a question of quantity hence the need for macro - I have over 30,000 rows in the spreadsheet.

    e.g.

    Cols A & C are the conditions to be met 25 & a
    Col B is the text to be copied if condition met.

    Before Macro

    .............Col A.........B...........C
    Row
    1................25.....Folder A.....a
    6................25.....................a
    10...............25

    After Macro

    .............Col A.........B...........C
    Row
    1................25.....Folder A.....a
    6................25.....Folder A.....a
    10...............25


    Thanks in advance.

    Denise
    Last edited by Denise Devlin; 02-12-2016 at 07:37 AM.

+ 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: 0
    Last Post: 01-13-2016, 08:50 PM
  2. copy paste row if conditions are met
    By SSJAMES18 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2015, 10:48 AM
  3. Copy paste cell from workbook to another under certain conditions
    By Cicada in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2014, 11:52 AM
  4. VBA to copy and paste according to conditions
    By andrewc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2014, 09:19 AM
  5. Macro to copy the data from sheet1 and to paste it in sheet2 with conditions.
    By Thinker8 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2014, 09:55 AM
  6. Macro to copy a table and paste in another table (based on certain conditions)
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-22-2013, 01:14 PM
  7. [SOLVED] Copy and Paste macro needs to paste to a changing cell reference
    By loulou in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2005, 07:06 AM

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