+ Reply to Thread
Results 1 to 2 of 2

Copy and paste previous value

  1. #1
    Registered User
    Join Date
    04-01-2014
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Copy and paste previous value

    Hi all,

    I am trying to automate the following (as attached)

    Where i get the previous cell value and automate names down with "Amy" until the next cell is updated with "John" names.

    Afterwards, i need to check if selected cells matches with another selected cell.

    Thank you all!


    Book1.xlsx

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Copy and paste previous value

    Try this code to see if this is what you want.
    Please Login or Register  to view this content.
    For detail see the attached sheet.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ 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] Macro to Concatenate, copy and paste the formula until the last row of the previous column
    By venkat.ramamoordhy1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2013, 04:03 PM
  2. [SOLVED] Find certain word, copy and paste cell in previous row if previous row is blank
    By steven_e in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2013, 12:53 PM
  3. Copy and paste data from Previous Month
    By dwalton5 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2011, 12:20 AM
  4. Need to Fin Last Row then copy / paste previous 6 rows and delete data
    By dwalton5 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-01-2011, 01:16 PM
  5. Copy and Paste from previous Row
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2008, 02:22 AM

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