+ Reply to Thread
Results 1 to 7 of 7

Macro to copy Item 8 rows above where reference is in Col A to where refrence is

  1. 04-01-2020, 02:44 AM #1
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,722

    Macro to copy Item 8 rows above where reference is in Col A to where refrence is

    I have text reference in Col A

    I would like the item 8 rows above where reference appears in Col A to be copied and pasted where reference appears on sheet1

    I have attached some sample data

    Your assistance in this regard is most appreciated
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-01-2020, 03:46 AM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,192

    Re: Macro to copy Item 8 rows above where reference is in Col A to where refrence is

    Howard...you will need to elaborate...makes no sense...
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 04-01-2020, 04:03 AM #3
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,518

    Re: Macro to copy Item 8 rows above where reference is in Col A to where refrence is 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 04-01-2020, 04:12 AM #4
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,192

    Re: Macro to copy Item 8 rows above where reference is in Col A to where refrence is

    @ jindon...You must be a mind reader lol...Could not understand OP request...My apologies
    Now that i see your code should it not be [RED 1]

    Col A to be copied and pasted where reference appears on sheet1 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 04-01-2020, 04:30 AM #5
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,518

    Re: Macro to copy Item 8 rows above where reference is in Col A to where refrence is

    No, it was very clear to me.
    Reply With QuoteRegister To Reply
  6. 04-01-2020, 04:45 AM #6
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,192

    Re: Macro to copy Item 8 rows above where reference is in Col A to where refrence is

    Understood
    Reply With QuoteRegister To Reply
  7. 04-01-2020, 04:56 AM #7
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,722

    Re: Macro to copy Item 8 rows above where reference is in Col A to where refrence is

    Thanks for the help Jindon
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. index Reference letter change when i insert a column in refrence sheet
    By AbdulkareemAlhassni in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-16-2019, 11:48 AM
  2. [SOLVED] Macro to insert 3 rows after the last item in each row
    By flupsie in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-18-2018, 08:13 AM
  3. Macro to copy and paste a row of formula down by x rows where x is in a reference cell
    By davidx in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-21-2015, 12:59 PM
  4. [SOLVED] Macro VBA to Copy & Paste Cell Item to another Cell Item
    By mave27 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-25-2015, 02:55 AM
  5. [SOLVED] Macro VBA to Copy & Paste Cell Item to another Cell Item
    By mave27 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-24-2015, 05:10 AM
  6. merge rows without cell refrence
    By nicci113 in forum Excel General
    Replies: 0
    Last Post: 05-21-2013, 07:31 AM
  7. VBA code to find item in list and copy adjacent 2 rows
    By bbook in forum Excel General
    Replies: 1
    Last Post: 01-18-2008, 07:01 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1