+ Reply to Thread
Results 1 to 2 of 2

Macro to connect different rows on different sheets

  1. #1
    Registered User
    Join Date
    10-21-2014
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    50

    Macro to connect different rows on different sheets

    I have data on one sheet (Data) that I am pulling from to fill my second sheet (Results).

    My Data is listed 1-100 on the rows (for example).

    However, on my Results sheet, each page is just for one row on the previous sheet (with a bunch of other data involved from the columns).

    When I try to copy/paste the Results page to make a second sheet, I want to be able to use from Data!A2. Instead, it gives me Data!A63 since the entire page is 62 rows.

    Is there a macro that I can use to make the copy/paste go to the next number in the sequence from the Data sheet instead of trying to equate how many spots I went down on the Result sheet?

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Macro to connect different rows on different sheets

    Why the double-post?
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.

+ 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] Need formula to connect sheets
    By besmir in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-25-2013, 01:41 PM
  2. connect rows
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-16-2012, 01:47 AM
  3. [SOLVED] How to connect the data in two sheets in one book?
    By freeSky in forum Excel General
    Replies: 10
    Last Post: 10-04-2012, 03:01 AM
  4. How to connect rows/cells in Excel?
    By tom333 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2007, 03:21 PM
  5. How do I connect 2 Excel Sheets to give auto answer on the 3rd
    By Maca in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-01-2005, 09:05 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