Results 1 to 6 of 6

Copy cells from last rows to another tab

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-28-2004
    MS-Off Ver
    Home/Office 2016
    Posts
    259

    Copy cells from last rows to another tab

    I need to copy the tab Name AND the A & B cells from the last row that has data - to the RESULTS tab
    Example:
    On the AL tab - copy A160 & B160 to the RESULTS tab then
    on the AR tab - copy A32 & B32 to the RESULTS tab under the AL tab data...etc...

    RESULTS
    AL (A160 data) (B160 data)
    AR (A32 data) (B32 data)

    {see attached}
    Attached Files Attached Files
    Last edited by x65140; 12-18-2014 at 10:38 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Split Cell Contents to New Rows & Copy Cells containing single values to the new rows
    By jaimelwilson in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-14-2017, 05:30 PM
  2. [SOLVED] Identify duplicate rows and copy/Paste the first cell to all cells of equal rows
    By vs5 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-15-2014, 06:31 AM
  3. [SOLVED] Insert rows based on the current cell value and, then, copy some cells into the new rows
    By Excel-RZ in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-03-2013, 05:19 PM
  4. Replies: 0
    Last Post: 06-06-2013, 02:03 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