+ Reply to Thread
Results 1 to 4 of 4

Find Last Row on Subsequent Tabs for Copy/Paste

  1. #1
    Forum Contributor
    Join Date
    08-08-2015
    Location
    NJ
    MS-Off Ver
    2013
    Posts
    205

    Find Last Row on Subsequent Tabs for Copy/Paste

    Hello, looking for assistance on dynamically copying/pasting a "key" from a master tab, to subsequent tabs, two rows after the last row of data. Each report run is different so the location of the key on the "master" tab will not be in the same location each time. I always need help with the 'finding last row' type coding, so hoping for help here, thanks in advance.

    On the "master" tab, the key will always be in columns A:C and begin with "BOLD =" which I believe the code could search for, then 1 row down, and 2 rows over. From there, those cells need to be copied/pasted to the other tabs the same, after the last row of data, 2 rows down.

    All subsequent tabs begin in row 9 and if there is no data in row 10, then the tab will be blank (contain no data) and there is no need for a key to be pasted.

    Attached is a sample showing what I am trying to accomplish. Thanks so much for any help on this.

    Sheryl
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: Find Last Row on Subsequent Tabs for Copy/Paste

    If your "Bold" cell is always the 2nd from last line then try...

    Please Login or Register  to view this content.
    Last edited by WasWodge; 12-26-2018 at 09:30 PM. Reason: Forgot an If test
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

  3. #3
    Forum Contributor
    Join Date
    08-08-2015
    Location
    NJ
    MS-Off Ver
    2013
    Posts
    205

    Re: Find Last Row on Subsequent Tabs for Copy/Paste

    Awesome! Thank you!

  4. #4
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: Find Last Row on Subsequent Tabs for Copy/Paste

    You're welcome

+ 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. How to change numbers from strings in subsequent tabs
    By melaniecoconut in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2018, 04:12 PM
  2. How to automate date in subsequent tabs
    By vikkam in forum Excel General
    Replies: 9
    Last Post: 09-03-2016, 06:37 PM
  3. Find most recent matching row and copy subsequent rows between workbooks
    By HRDFCE in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-13-2012, 09:02 AM
  4. [SOLVED] Macro to Find, copy, paste, find, copy, paste, find, copy, paste, u get the picture....
    By westsoldman in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-12-2012, 01:12 AM
  5. Find specific cell, copy row from several tabs and paste in summary sheet
    By helnil in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-11-2012, 08:16 AM
  6. Display front sheets to subsequent tabs
    By omletto in forum Excel General
    Replies: 2
    Last Post: 04-27-2010, 06:31 AM
  7. Can I have info on first tab transferred to subsequent tabs?
    By Jaime P in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-08-2005, 12:06 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