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

My task is to add another column to a backlog and link data from another worksheet to the backlog. The data should be linked to the corresponding subtotal row in the backlog by inputting the data to a new column in the backlog. The problem is that I can't figure out how to link the cells without going one-by-one. Each time I've tried I've come into issues that have to do with data hiding. Since I have to do this with large amounts of information, I don't have the time to do this work one-by-one. Is there any time-efficient solution for this?

share|improve this question
1  
Are you familiar with the vlookup function? – F106dart Jun 11 '12 at 19:03
    
Yes, there are time-efficient solutions for this-but it would be very helpful for you to add some sample data to help us better understand your problem. – dav Jun 14 '12 at 1:23

In 'new column' first subtotal row, lookup the value of what you want from the row immediately above. Filter on subtotals and copy down the new formula.

share|improve this answer

You must log in to answer this question.

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