+ Reply to Thread
Results 1 to 3 of 3

Trying to make function that pulls entire row from another sheet, that is all.

  1. #1
    Registered User
    Join Date
    11-22-2021
    Location
    Colorado USA
    MS-Off Ver
    google sheets
    Posts
    9

    Question Trying to make function that pulls entire row from another sheet, that is all.

    So all y'all need to know is I have 3 sheets, 2 of those sheets have raw data that will have 1-5 additions made (1-5 new rows) every day.

    the 3rd sheet has to have some raw data from sheet 1 and 2 in a specific order.
    right now I am either manually copying the 2 rows (one row from sheet 1 & 2) into a predetermined area OR single cell calling with ! ::: and the rest of my sheet 3 fills out, however, I would like to streamline this a bit.

    I want to pull an entire row all at once with a formula, so that all I would need to do is change the row in the formula from row 14 (for example), to row 15 and have all of the cells containing data from row 14 pasted on sheet number 3 change to all the cells from row 15.

    if this is a very common thing please let me know how I can google this. or even a youtube video.

    I don't want to have copy paste because I don't want coworkers to TOUCH the raw data (sheet 1 & 2), I want them to -only- touch sheet 3.

    ******The best case scenario would be a cell above the function that they can type a number (1-XX) and the formula pulls from that cell to decide the row.




    TLDR: how do I copy an entire row to a new sheet with just one button/formula.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,651

    Re: Trying to make function that pulls entire row from another sheet, that is all.

    On Sheet3 Cell A1, type the row number that you want to copy from Sheet1. The formulas below will copy that row

    Copy Sheet1 row n, column A
    =INDIRECT("Sheet1!A" & A1)

    Copy Sheet1 row n, column B
    =INDIRECT("Sheet1!B" & A1)

    Copy Sheet1 row n, column C
    =INDIRECT("Sheet1!C" & A1)


    Excel INDIRECT Function Guide
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    11-22-2021
    Location
    Colorado USA
    MS-Off Ver
    google sheets
    Posts
    9

    Re: Trying to make function that pulls entire row from another sheet, that is all.

    THANK YOU! So simple and you just saved me 5-10 minutes a day for the rest of my year (and years to come if we keep the system we have in place).

+ 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. Function that pulls a value from another sheet based on two cells value
    By rittyboy32 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2021, 05:33 PM
  2. How to make a chart that pulls from the same cell on multiple sheets?
    By kelemvor in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-09-2017, 04:11 PM
  3. [SOLVED] need help with a macro to make certain text within the entire sheet BOLD
    By s2h in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-20-2017, 09:09 PM
  4. Need to make a workbook that pulls and organizes data froma master sheet
    By cvnhrman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-15-2015, 06:15 PM
  5. [SOLVED] HELP PLEASE : How to make macros to search a word in the entire sheet & c/p the value
    By kinabuch0902 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 08-26-2013, 11:36 PM
  6. Replies: 1
    Last Post: 07-31-2013, 10:21 AM
  7. search function but how do i make it select the entire row
    By BouncingHippo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2008, 11:20 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