+ Reply to Thread
Results 1 to 4 of 4

Copy paste value from variable rows below

  1. #1
    Registered User
    Join Date
    04-22-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    6

    Copy paste value from variable rows below

    Hi

    Help wanted please for a newbie.

    I would like to copy data from a row below and paste it into the empty cells above. This needs to be repeated for different employees (and the no. of people / rows per person change).

    See attached - cols A to C = before macro; D to F = after macro. I have highlighted in yellow the cells that need to be populated by the macro.

    Thank you
    Attached Files Attached Files
    Last edited by Monty59; 07-23-2014 at 10:19 AM.

  2. #2
    Registered User
    Join Date
    02-06-2013
    Location
    Ezinge, The Netherlands
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013
    Posts
    65

    Re: Copy paste vale from variable rows below

    Hi Monty59,

    Please find updated sheet attached,

    In this a macro (use with ALT+F8 to run it).
    The macro starts at last row (=r) and works way up, one at the time (=i)
    In case field was empty the last value is used as employee, in case not empty, the value found will be used as next employee.

    Please let me hear your thoughts.

    Kind regards,

    Tom

    Please Login or Register  to view this content.
    variable-rows-below.xlsm

  3. #3
    Registered User
    Join Date
    04-22-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Copy paste vale from variable rows below

    Excellent Tom. Thank you

    So easy when you know how!

  4. #4
    Registered User
    Join Date
    02-06-2013
    Location
    Ezinge, The Netherlands
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013
    Posts
    65

    Re: Copy paste value from variable rows below

    Hi Monty59,

    No problem, my pleasure :-)
    And if you'd like to 'add reputation' to me... :-)
    Last edited by thelongpants; 07-25-2014 at 03:30 AM. Reason: it's already set to 'solved'

+ 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. paste many rows and add a counter variable
    By IonVasi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-06-2013, 10:55 PM
  2. Need code to copy and paste based on variable rows
    By bonnie6850 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-04-2013, 01:51 AM
  3. [SOLVED] Find duplicate values and then copy adjasent vale to empty cell
    By dettrix in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2012, 09:26 AM
  4. Copy Rows That Match Variable Criteria And Paste To A New Worksheet
    By BrodyNoochie in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-19-2012, 04:20 PM
  5. Find, Copy, Paste variable rows to another sheet
    By wkhor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2011, 07:37 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