View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Fill down Multiple Rows?

Debra Dalgleish shares some techniques:
http://contextures.com/xlDataEntry02.html

Katie wrote:

This is my question... I have a report generated from access that lists
information in a "tree" like format with the parent information, and then kid
information (it varies how many lines) in the next column over. Is there a
way to copy each parent org below itself so that each row has a parent name
in it?

In the example below, I want something that can help me drag down the org
names into each box below it. Is this possible?

For example;

ABCD Corp John Smith
Jane Doe
1234 Corp George Michael
Bill Rogers
Jim Greene


--

Dave Peterson