Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill down Multiple Rows?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill down Multiple Rows?
My way:
in the cell directly below ABCD corp, type =A2 (or whatever cell the above value is in). copy the formula Highlight the entire column Edit Go To Special Blanks Paste your formula Copy the column and paste Special/Values to get rid of the formula. "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill down Multiple Rows?
Katie
Select the org names column and F5SpecialBlanksOK Type an = sign in the active cell then click on or up arrow to the cell above. Hit CTRL + ENTER to copy down. When happy, select tha column and EditCopy. EditPaste Special(in place)ValuesOKEsc. Gord Dibben MS Excel MVP On Wed, 21 Feb 2007 09:23:43 -0800, 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill down Multiple Rows?
Sean,
I agree this would work if it was the same number of entries for each parent, but it varies per parent info in the first column. Sometimes there is one name, sometimes there's 15. Would this still work? "Sean Timmons" wrote: My way: in the cell directly below ABCD corp, type =A2 (or whatever cell the above value is in). copy the formula Highlight the entire column Edit Go To Special Blanks Paste your formula Copy the column and paste Special/Values to get rid of the formula. "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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill down Multiple Rows?
Okay- this is awesome! Thank you so much!
I had never used that "go to" menu before. I think I might try to play around with it! Thank you all! "Gord Dibben" wrote: Katie Select the org names column and F5SpecialBlanksOK Type an = sign in the active cell then click on or up arrow to the cell above. Hit CTRL + ENTER to copy down. When happy, select tha column and EditCopy. EditPaste Special(in place)ValuesOKEsc. Gord Dibben MS Excel MVP On Wed, 21 Feb 2007 09:23:43 -0800, 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill rows with alternating data ? | Excel Discussion (Misc queries) | |||
Counting Rows - Fill ??? | Excel Worksheet Functions | |||
Pivot tables - Fill In All Rows | Excel Discussion (Misc queries) | |||
Is it possible to fill rows in Excel beyond 65536? | Excel Discussion (Misc queries) | |||
Fill down to nonblank rows | Excel Worksheet Functions |