Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.