Pull row of data from one place in spreadsheet to another

Posted by bookcasey on Super User See other posts from Super User or by bookcasey
Published on 2012-07-05T18:59:33Z Indexed on 2012/07/05 21:18 UTC
Read the original article Hit count: 267

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 Numbers.app, but am curious if this is possible in Excel, OpenOffice Calc, Google Docs, or any other spreadsheet program. Thank you.

© Super User or respective owner

Related posts about microsoft-excel

Related posts about spreadsheet