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

So sheet 1 is currently empty and on sheet 2 i have the following:

Column A Column B Column C Column D

Hobbies travelling swimming Jogging

What do i have to do so that if i write Hobbies in Column A of Sheet 1, Columns B, C and D of Sheet 1 are filled in automatically with the contents of Columns B,C and D of Sheet 2?

share|improve this question
Welcome to Superuser. This may sound trivial, but I just want to clarify your question; you are asking for sheet1 to reflect what you put in the columns of sheet2? Or are you wanting the data on sheet2 to be the first sheet of the workbook? – CharlieRB Jun 13 '12 at 11:45

Try this

Put this formula in cells B1, C1, D1 of Sheet1, then copy down as far as needed

share|improve this answer
Good answer (more versatile than @James' solution) - shame OP has not bothered to accept it. – pnuts Dec 5 '12 at 9:27

=if(a1 = "Hobbies", b1:d1 = Sheet2!b1:Sheet2!d1,"")

What we are saying is cell a1 (column a, row 1) = Hobbies then cells b1 through d1 = the cells b1 through d1 of Sheet2 otherwise leave it blank.

share|improve this answer

You must log in to answer this question.

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