+ Reply to Thread
Results 1 to 2 of 2

auto-populate based on input

  1. #1
    Registered User
    Join Date
    06-08-2012
    Location
    Edmonton, Alberta
    MS-Off Ver
    Excel 2010
    Posts
    3

    Exclamation auto-populate based on input

    I don't know if anyone will be able to help me, but I'm kind of an idiot when it comes to excel. I'll try to explain this as well as I can.
    I'm using Excel 2010, Windows 7 64 bit.
    I have a Excel Book with different sheets (the tabs at the bottom).
    On one sheet I have a bunch of data (3000 rows and 5 columns) I'll call this Sheet 1
    I want to be able to go to a blank sheet (Sheet 2) go to A1 type in data from Sheet 1 (let's say G1) and have the whole 'A' row automatically filled in with the data from 'row G'

    Sorry if this doesn't make sense! Thanks!

  2. #2
    Forum Contributor
    Join Date
    06-07-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    189

    Re: auto-populate based on input

    Take a look at VLOOKUP http://www.contextures.com/xlFunctions02.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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