Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a list of names and their assorted properties.

Spreadsheet Data

I am trying to find a way to quickly move an entire row's worth of data into a different sheet so I can manipulate it.

Moving a Row

Currently I can accomplish this by copy and pasting the entire row, but this is not elegant nor dynamic (the number in blue does not update with this method):

Copy and Paste is not Dynamic

My ideal solution: A name is typed into the "Name" column. The spreadsheet program pulls the associated row from the "main" sheet into the new sheet.

Autocomplete and autofill row

I am currently using, but am curious if this is possible in Excel, OpenOffice Calc, Google Docs, or any other spreadsheet program. Thank you.

share|improve this question
What you're looking to do sounds more like database work than spreadsheet. – techturtle Jul 5 '12 at 19:11
You've tagged a lot, so which program are you using? As far as Excel, have you tried VLOOKUP? – CharlieRB Jul 5 '12 at 19:44
you want updates in the source sheet to stay connected, or a formula in the source sheet to be duplicated in the target sheet? – datatoo Jul 6 '12 at 0:04
up vote 2 down vote accepted

In Excel VLOOKUP "Searches for a value in the first column of a table array and returns a value in the same row from another column in the table array."

Taking your info as posted, I created a table on the first sheet and this on the second sheet;

enter image description here


Type the name into A2 and B2 will look up the color value for the name "Dagger" in the first column of the first sheet. You will notice the array Sheet1!A1:D6 given in the formula, that is your table on the first sheet. The number 2 is the column to get the data from. So to get the size, change the column index to 3 and so on.

If you change the data in the table on the first sheet, the data will update.

share|improve this answer

In Google Spreadsheets, you can go about this in many ways. I like to use the FILTER function. Use the following syntax:


You must (may) start at A2 to skip the headers.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .